I am currently working on generating a multi-line graph to plot count of 3 different parameters (x, y, z) per hour for each day. I'm facing 2 challenges here :
1. Using a php script I've connected to the SQL Server. Currently I'm getting an array of all values in my resultset, however I need to pass only values from 4 columns to the chart, and I'm not sure how to filter out the data. 2. The date is stored in the DB in the following format : 2015-09-20 00:13:43.000 I'm not sure how to get it to the google charts time format of [00,13,43]. Google charts expects a json format to handle graphs, I understand I would need to get the following format in order to plot my graph : [[00,13,43], 45, 50, 60]] : where 45, 50, and 60 are the counts of different parameters, and [00,13,43] would be the time along the X axis. Any help would be much appreciated! Thanks -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/73ce19da-4a07-4183-936f-d71b60ac9aec%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
