Thanks Sergey. I change the first column to a string (the dates being just the axis in the graph and it worked fine).
It appears you can not have a date field in col 1 when calling the LineChart function (I tried the correct syntax). Pete On Tuesday, 1 March 2016 16:08:47 UTC+1, Sergey wrote: > > Hi Pete, > > Your JSON is not syntactically valid. Having "2016-03-02" as a raw value > is not proper. Please refer to our Dates and Times documentation page > <https://developers.google.com/chart/interactive/docs/datesandtimes> for > guidance on how to use dates properly. > > On Tue, Mar 1, 2016 at 8:15 AM Pete Carlile <[email protected] > <javascript:>> wrote: > >> Hi, trying to use a json create table and run though Google charts line >> chart. Getting error message. Any ideas. >> >> File being sent : >> >> { "cols" : [{"id" : >> "","label":"Date","pattern":"","type":"date"},{"id":"","label":"GBP","pattern":"","type":"number"},{"id":"","label":"USD","pattern":"","type":"number"},{"id":"","label":"CHF","pattern":"","type":"number"}], >> >> "rows" : [{"c" : [{"v":2016-02-29, "f":null},{"v":35657.00, >> "f":null},{"v":1000.00, "f":null},{"v":6626.45, "f":null}]},{"c" : >> [{"v":2016-03-01, "f":null},{"v":35657, "f":null},{"v":1000, >> "f":null},{"v":6626.45, "f":null}]},{"c" : [{"v":2016-03-02, >> "f":null},{"v":35657, "f":null},{"v":1000, "f":null},{"v":6626.45, >> "f":null}]},{"c" : [{"v":2016-03-03, "f":null},{"v":35657, >> "f":null},{"v":1000, "f":null},{"v":6626.45, "f":null}]},{"c" : >> [{"v":2016-03-04, "f":null},{"v":35657, "f":null},{"v":1000, >> "f":null},{"v":6626.45, "f":null}]},{"c" : [{"v":2016-03-05, >> "f":null},{"v":35657, "f":null},{"v":1000, "f":null},{"v":6626.45, >> "f":null}]}]} >> >> -- >> 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] >> <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> 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/0a14c8ef-f10e-4202-90ad-1b3ec5c6f44f%40googlegroups.com >> >> <https://groups.google.com/d/msgid/google-visualization-api/0a14c8ef-f10e-4202-90ad-1b3ec5c6f44f%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- > > *[image: unnamed.gif]• Sergey Grabkovsky• Software Engineer• Google, Inc• > [email protected] <javascript:>* > > -- 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/252fe07c-463e-4324-ba81-9b17bc7dc8d9%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
