datetime format in Google Charts (Areachart)

809 views
Skip to first unread message

Tijger Visuals

unread,
Oct 12, 2015, 3:20:53 AM10/12/15
to Google Visualization API

Hello,


i've tried a lot of different formats but somehow cannot seem to get the datetime format right for an area-chart in google charts.

As soon as i set the column to 'string' everything works, but i feel like i should use datetime.

The data-array is supplied by a php-include that reads from a MySQL database and i should be able to create anything you feed me ;)


Thanx for reading (and possibly helping me).


Daniel LaLiberte

unread,
Oct 12, 2015, 11:02:52 PM10/12/15
to Google Visualization API
Hi

Your datetime values are actually strings that would have to be parsed, but the parsing turns out to be problematic.  You should read up on dates and times for Google Charts on this page:  https://developers.google.com/chart/interactive/docs/datesandtimes


--
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 google-visualizati...@googlegroups.com.
To post to this group, send email to google-visua...@googlegroups.com.
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/6b39330f-eb44-4e26-8a19-f95be432ddbc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
dlaliberte@Google.com   5CC, Cambridge MA
daniel.laliberte@GMail.com 9 Juniper Ridge Road, Acton MA

Tijger Visuals

unread,
Oct 13, 2015, 9:50:01 AM10/13/15
to Google Visualization API
Thanks Daniel,

Took some recoding of my fetching of data from the database, but doable for a complete nitwit ;)
See picture!



Op dinsdag 13 oktober 2015 05:02:52 UTC+2 schreef Daniel LaLiberte:
Hi

Your datetime values are actually strings that would have to be parsed, but the parsing turns out to be problematic.  You should read up on dates and times for Google Charts on this page:  https://developers.google.com/chart/interactive/docs/datesandtimes

On Mon, Oct 12, 2015 at 3:20 AM, Tijger Visuals <tijger...@gmail.com> wrote:

Hello,


i've tried a lot of different formats but somehow cannot seem to get the datetime format right for an area-chart in google charts.

As soon as i set the column to 'string' everything works, but i feel like i should use datetime.

The data-array is supplied by a php-include that reads from a MySQL database and i should be able to create anything you feed me ;)


Thanx for reading (and possibly helping me).


--
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 google-visualization-api+unsub...@googlegroups.com.



--
dlali...@Google.com   5CC, Cambridge MA
daniel.l...@GMail.com 9 Juniper Ridge Road, Acton MA
Reply all
Reply to author
Forward
0 new messages