Hi there, I'm pretty new to the data visualization game. I'm wondering if the following is possible with dataTables/dataViews or if I should do it in PHP.
I am building a charting application that charts a dataset using a Line Chart at 5 min intervals, however I would like to be able to show a monthly overview of sums and averages in a Column Chart form. Can I use my existing dataTable (5min intervals) to build a dataTable that aggregates the data into a daily average or sum? IE. table 1 showing 5 min interval raw data NB - times are really dateobjects Timetemperaturerainfall52511022215250202502526030271etcetcetc table 2 showing aggregate data based on table 1 Daytemperature (avg)rainfall (sum)Mon2510Tues242Wed220Thurs260Fri260 I think I know how to do it in PHP, so I could build a new dataTable of this info that way, but I feel like is would be more efficient to use the dataTable I already have. I would appreciate any advice you might have. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/groups/opt_out.
