You can use a ChartRangeFilter<https://developers.google.com/chart/interactive/docs/gallery/controls#chartrangefilter>to handle the zooming duties - the only requirement would be that your domain (x-axis) data would have to be input as a continuous data type (number, date, datetime, timeofday); since you are using unix timestamps, it shouldn't be a problem for you to convert those into javascript Date objects.
As far as the chart types go, generally I find that time series data like you have is best handled with line charts. You will have to figure out what makes the most sense to group together into one chart, or you could leave it up to your users to decide and implement some kind of mechanism for the user to decide what data series to display (I have two examples, one hacks a CategoryFilter into selecting a data series<http://jsfiddle.net/asgallant/WaUu2/>, the other turns series on and off by clicking the legend labels<http://jsfiddle.net/asgallant/6gz2Q/> ). On Sunday, October 6, 2013 1:37:03 PM UTC-4, Russell Purinton wrote: > > Hi Group, I'm new. I created a script that polls server performance > statistics (CPU, Memory, Bandwidth) ... every 10 seconds and logs to a > MySQL Database. Every so often the recent results are averaged and stored > in separate tables to be able to display long term statistics without > saving all the 10 second records. In my first attempt at Google charts I > have managed to make all sorts of basic easy graphs already (see picture > below) > > I'm seeking suggestions for a chart type that I can use to get away from > drawing 20 different charts. Preferably a single chart that shows all the > statistics in one with the ability for variable zoom anywhere from 10 > minutes to 31 days or more. > > I know how to join all the SQL records into a single dataset easy enough. > Every record has a unix timestamp. The H axis would need to be formatted > as date/time. > > What does the group think would be the best fit for this application? > > > > <https://lh3.googleusercontent.com/-sKqvU0R2f0k/UlGeUQ88mTI/AAAAAAAAACE/JtkdZ9jLte8/s1600/dashboard.PNG> > > -- 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.
