Ultimately, I am after something like this <https://storage.googleapis.com/gfiske.us/energy_whrc/netPiChart_test.html>. While populating the numeric portion of each value pair from the spreadsheet query.
Thanks again. On Thursday, October 20, 2016 at 4:09:02 PM UTC-4, Daniel LaLiberte wrote: > > Hi Greg, > > You can format the number as a string, and then create a DataView with the > string as your data. But I am not sure that is really what you want. For > a PieChart, you need to provide a list of pairs of values, a discrete value > (a string) and an number. Why would it make sense to use a number as a > discrete value? > > > On Thu, Oct 20, 2016 at 4:00 PM, Greg Fiske <[email protected] > <javascript:>> wrote: > >> Thank you Daniel - this is very helpful. And it fills in some gaps as I >> am learning this API. >> >> I'm sorry for the naive followup question, but is there a way to convert >> the returned dataTable to the type (string) expected by PieChart? >> >> Greg >> >> On Thursday, October 20, 2016 at 11:24:32 AM UTC-4, Daniel LaLiberte >> wrote: >>> >>> Hi Greg, >>> >>> There were three main problems with your example, which I fixed here: >>> https://jsfiddle.net/dlaliberte/16awtj3w/2/ >>> >>> - You were not loading the loader. >>> - Your handleQueryResponse function was not being called. >>> - Your data is not of the correct type as expected for PieChart. I >>> substituted in Table so you can see what is coming back. >>> >>> >>> >>> On Wed, Oct 19, 2016 at 9:30 PM, Greg Fiske <[email protected]> wrote: >>> >>>> Hi folks - I'd like to query a Spreadsheet and use the results in a Pie >>>> Chart. I'm having trouble getting the chart to draw. Here's my example: >>>> >>>> https://jsfiddle.net/16awtj3w/ >>>> >>>> I appreciate any advice that you may provide, >>>> >>>> thanks, >>>> >>>> Greg >>>> >>>> -- >>>> 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/3c0fcdf6-193e-4c13-a41c-59c169d4cc6e%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/google-visualization-api/3c0fcdf6-193e-4c13-a41c-59c169d4cc6e%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >>> [email protected] 5CC, Cambridge MA >>> >> -- >> 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/d910817a-0dc6-4c81-b06d-1c06830f5ab6%40googlegroups.com >> >> <https://groups.google.com/d/msgid/google-visualization-api/d910817a-0dc6-4c81-b06d-1c06830f5ab6%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> > [email protected] <javascript:> 5CC, Cambridge MA > -- 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/368a38a4-5402-4f72-8ad7-620230a0813d%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
