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/-/3_P0-xFJ1B4J.
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.
