[visualization-api] Joining 2 JSON tables

2017-04-01 Thread darren.macl...@internode.on.net
Hi All, I am trying to join 2 json tables to display as on graph the tables are $jsonTable & $jsonTable2. both of these contain temperature and time entries from separate sensors and gathered at different times. I have looked at the join example here http://code.google.com/apis/visualization/docu

[visualization-api] Re: Timezone Offset Error

2017-02-18 Thread darren.macl...@internode.on.net
> > Sorry Daniel, I posted my last reply before I saw you response. Indeed > adding the year was one of the changes I made. > Any suggestions on the timezone offset? > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubs

[visualization-api] Re: Trendlines and dates on linecharts.

2017-01-27 Thread darren.macl...@internode.on.net
Hi Steve, I am having the same issue with date time and was wondering if you managed to resolve it? As with your experience, the only time I get any result is when I use the datetime in a string format. I decided to echo the json to try and determine what was going on. Out of the whole datetim

[visualization-api] Re: Timezone Offset Error

2017-01-27 Thread darren.macl...@internode.on.net
I think that this is where I need to make the changes to the above code, but just not sure how to change $temp[] = array('v' => (float) $r['Time']); Any suggestions? On Tuesday, January 24, 2017 at 1:57:25 PM UTC+11, darren@internode.on.net wrote: > Hi All, > I am new to Google ch

[visualization-api] Re: Timezone Offset Error

2017-01-26 Thread darren.macl...@internode.on.net
I still had no luck in getting the table chart to work, however I did manage to echo the json and it looks like this where the problem is. for some reason the json output is only showing the year, not the whole date time. I have also managed to echo the datetime correctly (prior to json conve

[visualization-api] Re: Timezone Offset Error

2017-01-24 Thread darren.macl...@internode.on.net
Hi Daniel, - ID - Int(11) - Time - datetime - Temperature - double ID - Datetime - Temperature 6065 - 2017-01-24 21:00: - 29.375 6064 - 2017-01-24 20:42: - 29.125 6063 - 2017-01-24 20:29: - 28.875 To create the table chart, do I just change the chart type from LineChar

[visualization-api] Timezone Offset Error

2017-01-23 Thread darren.macl...@internode.on.net
Hi All, I am new to Google charts and this forum. For some time now I have been trying to graph temperature against time from data I am logging to MySQL, using a variety of different applications / java scripts / methods. It was not until I first tried Google Charts that I was able to achieve any