Awesome, that's worked for me. Thanks for your help.
On Thursday, 21 June 2012 16:49:17 UTC+1, asgallant wrote: > > I'm not sure what to do to make that work, but you can skip trying to > format in the query and format in JS instead, using a > NumberFormatter<https://developers.google.com/chart/interactive/docs/reference#numberformatter> > . > > On Thursday, June 21, 2012 10:04:19 AM UTC-4, Raul Marengo Lopez wrote: >> >> hi there, >> >> I have the following query: >> >> query.setQuery('SELECT A, avg(F) group by A ' ); >> >> >> And I would like to format avg(F) to have no decimal point. >> >> I am trying: >> >> SELECT A, avg(F) group by A format F '#' >> >> >> But this results in an invalid column [F] error. >> >> I have tried "format avg(F) '#'" but that shows the same error and I >> haven't been able to find the actual syntax for calculated fields in the >> documentation. >> >> Any help is appreciated. >> >> Thanks! >> > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/MJz_IanANNMJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
