Hi there,
I'll hold my hands up right now and say that I'm new to Google Charts, so
apologies in advance if this is a noob question!
I am trying to create a line chart of temperature information, collected by
Raspberry Pi, from within my house. The data is stored in a MySQL database
in the following format:
* tdate ttime zone
temperature*
2017-05-14 17:24:17 Living Room Out Box 19
2017-05-14 17:24:23 Living Room In Box 20
2017-05-14 17:24:31 Living Room Out Box 20
2017-05-14 17:24:42 Living Room In Box 20
2017-05-14 17:24:48 Living Room Out Box 20
2017-05-14 17:24:53 Living Room In Box 20
2017-05-14 17:24:59 Outside 15
2017-05-14 17:25:05 Living Room In Box 20
2017-05-14 17:25:12 Living Room Out Box 20
2017-05-14 17:25:18 Living Room In Box 20
2017-05-14 17:25:23 Outside 15
2017-05-14 17:25:29 Living Room In Box 20
2017-05-14 17:25:35 Living Room Out Box 20
2017-05-14 17:25:41 Living Room In Box 20
I am trying to plot a graph that has a line for each zone, similar to below:
<https://lh3.googleusercontent.com/-lF-dlnsaTiA/WS68JBGNQ7I/AAAAAAAAy8E/GJ5sTZK7GrMf3T50Um86et5dg8uJNLRAgCLcB/s1600/Screen%2BShot%2B2017-05-31%2Bat%2B13.38.16.png>
I cannot fathom how I need to organise my DataTable in order to account for
the way in which the data is being returned. I will be adding thermometers
to the house as I progress with the renovations, so I'd like to be able to
cater for data where a line is plotted that may start half way through the
results set when that thermometer comes online (see "Outside" zone for
example).
In order to set the columns and data in the way I've seen in all tutorials
and examples, I would need to know the order in which they appear in the
database. However the data is not in that format as I've added thermometers
as I've progressed, plus due to the way in which the thermometers work they
might all be writing at slightly different times, so I cannot easily order
the data to create the table orientation below (example I've found online
showing add rows used when order is known):
data.addColumn('number', 'Day');
data.addColumn('number', 'Guardians of the Galaxy');
data.addColumn('number', 'The Avengers');
data.addColumn('number', 'Transformers: Age of Extinction');
data.addRows([
[1, 37.8, 80.8, 41.8],
[2, 30.9, 69.5, 32.4],
[3, 25.4, 57, 25.7],
[4, 11.7, 18.8, 10.5],
[5, 11.9, 17.6, 10.4],
[6, 8.8, 13.6, 7.7],
[7, 7.6, 12.3, 9.6],
[8, 12.3, 29.2, 10.6],
[9, 16.9, 42.9, 14.8],
[10, 12.8, 30.9, 11.6],
[11, 5.3, 7.9, 4.7],
[12, 6.6, 8.4, 5.2],
[13, 4.8, 6.3, 3.6],
[14, 4.2, 6.2, 3.4]
This might just be down to the way in which I need to group or order the
data in my SQL SELECT statement. But I can't seem to figure it out!! Is
there a means by which I can group/order/add the data in the DataTable
object to achieve what I need to do/see?
Any help would be very much appreciated!
Thanks! Matt
--
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 https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/20a2e9aa-04e8-48d6-9a75-536221c457fc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
