AnnotationChart with data from json

43 views
Skip to first unread message

Sriharsha Puranik

unread,
Jun 2, 2016, 7:15:32 PM6/2/16
to Google Visualization API
Hi,

I am trying to create a AnnotationChart with json data. But, I get this error - 

Type mismatch. Value 15155 does not match type number

This is the json string I am using - 
json_str = '{"cols":[{"label":"Date","type":"date"},{"label":"Area","type":"number"}],"rows":[{"c":[{"v":"Date(2016, 4, 20)"},{"v":"15155","f":null}]},{"c":[{"v":"Date(2016, 4, 21)"},{"v":"15181","f":null}]},{"c":[{"v":"Date(2016, 4, 22)"},{"v":"15188","f":null}]},{"c":[{"v":"Date(2016, 4, 23)"},{"v":"15203","f":null}]}]}';

This same json string works fine for line chart - 

Also, from official example on AnnotationChart, it works fine with data.addRows function - 

So, is there anyway to work around this issue?

Thanks,
Sriharsha Puranik.

Daniel LaLiberte

unread,
Jun 3, 2016, 6:49:10 AM6/3/16
to Google Visualization API
The inconsistency is a bug, so thanks for reporting it.  But you can work around it if you just use numbers instead of strings for your number values.

--
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 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/c22c967d-8bb1-49be-8002-d22a5b0fa8d2%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--

Sriharsha Puranik

unread,
Jun 3, 2016, 5:48:57 PM6/3/16
to Google Visualization API
Thanks Daniel. I missed the quotes on the numbers in the json string.

I have another query.

I want to use AnnotationChart for plotting data collected for few hours a day on weekdays. So, is it possible to plot only specific hours/days on the chart?
Eg:
[{"c":[{"v":"Date(2016, 4, 20, 10, 00, 00)"},{"v":18.0,"f":null}]},
{"c":[{"v":"Date(2016, 4, 20, 10, 15, 00)"},{"v":18.4,"f":null}]},
{"c":[{"v":"Date(2016, 4, 20, 10, 30, 00)"},{"v":18.9,"f":null}]},
{"c":[{"v":"Date(2016, 4, 20, 10, 45, 00)"},{"v":18.6,"f":null}]},
{"c":[{"v":"Date(2016, 4, 20, 11, 00, 00)"},{"v":18.2,"f":null}]},
{"c":[{"v":"Date(2016, 4, 21, 10, 00, 00)"},{"v":18.0,"f":null}]},
{"c":[{"v":"Date(2016, 4, 21, 10, 15, 00)"},{"v":18.4,"f":null}]},
{"c":[{"v":"Date(2016, 4, 21, 10, 30, 00)"},{"v":18.9,"f":null}]},
{"c":[{"v":"Date(2016, 4, 21, 10, 45, 00)"},{"v":18.6,"f":null}]},
{"c":[{"v":"Date(2016, 4, 21, 11, 00, 00)"},{"v":18.2,"f":null}]},
{"c":[{"v":"Date(2016, 4, 22, 10, 00, 00)"},{"v":18.0,"f":null}]},
{"c":[{"v":"Date(2016, 4, 22, 10, 15, 00)"},{"v":18.4,"f":null}]},
{"c":[{"v":"Date(2016, 4, 22, 10, 30, 00)"},{"v":18.9,"f":null}]},
{"c":[{"v":"Date(2016, 4, 22, 10, 45, 00)"},{"v":18.6,"f":null}]},
{"c":[{"v":"Date(2016, 4, 22, 11, 00, 00)"},{"v":18.2,"f":null}]},]}';

Above data has only data for an hour from 10 AM to 11 AM. But AnnotationChart plots for 24 hours and so there are gaps in the plot (attached).

Let me know if it is possible to skip all the times there is no data.

Thanks,
Sriharsha Puranik.


On Friday, June 3, 2016 at 3:49:10 AM UTC-7, Daniel LaLiberte wrote:
The inconsistency is a bug, so thanks for reporting it.  But you can work around it if you just use numbers instead of strings for your number values.
On Thu, Jun 2, 2016 at 7:15 PM, Sriharsha Puranik <crih...@gmail.com> wrote:
Hi,

I am trying to create a AnnotationChart with json data. But, I get this error - 

Type mismatch. Value 15155 does not match type number

This is the json string I am using - 
json_str = '{"cols":[{"label":"Date","type":"date"},{"label":"Area","type":"number"}],"rows":[{"c":[{"v":"Date(2016, 4, 20)"},{"v":"15155","f":null}]},{"c":[{"v":"Date(2016, 4, 21)"},{"v":"15181","f":null}]},{"c":[{"v":"Date(2016, 4, 22)"},{"v":"15188","f":null}]},{"c":[{"v":"Date(2016, 4, 23)"},{"v":"15203","f":null}]}]}';

This same json string works fine for line chart - 

Also, from official example on AnnotationChart, it works fine with data.addRows function - 

So, is there anyway to work around this issue?

Thanks,
Sriharsha Puranik.

--
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.



--
Screenshot - 6_3_2016 , 2_47_02 PM.png

Daniel LaLiberte

unread,
Jun 3, 2016, 10:00:51 PM6/3/16
to Google Visualization API
We don't yet have a way of skipping the gaps.  Eventually we expect to support that, however.

To unsubscribe from this group and stop receiving emails from it, send an email to google-visualizati...@googlegroups.com.



--

--
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 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/7f7bb056-2269-464e-9324-aaa9a6fd91bc%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--
Reply all
Reply to author
Forward
0 new messages