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/-/arvTvfa22-YJ.
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.
