I'm removing top-posting ... hope you do not mind .
On 8/4/13, asgallant <[email protected]> wrote:
> On Sunday, August 4, 2013 1:20:48 AM UTC-4, olemis wrote:
>>
>> Is there any way to perform integer division (i.e. div , mod
>> operators) using the Google Charts query language ? I've read the docs
>> and found nothing about that , only / arithmetic operator .
>>
>> TIA
>>
>
> To the best of my knowledge, you can't do integer operations in the query
> language.
I confirm my suspicion then . I just thought that something was
missing in the docs .
> Once the data is retrieved, you can use javascript to modify it
> and "fix" the division if you need to. As an example, if you have a
> DataTable "data" with the result of a division in column 1, you can fix it
> with this:
>
> for (var i = 0; i < data.getNumberOfRows(); i++) {
> data.setValue(i, 1, Math.floor(data.getValue(i, 1)));
> }
>
Thanks for the pointer , however I do not think that will work for me
. I need the expression to create groups in a query (i.e. group by and
pitvot clauses) . In my case I've just written my own query engine .
It will be easy (for me) to add div and mod just like if they were yet
another operators . I just wanted to explore whether this was
available so as to keep as compatible to the specs as possible .
Would this be a good idea for a new version (0.8 ?) of the query language ?
--
Regards,
Olemis - @olemislc
Apache™ Bloodhound contributor
http://issues.apache.org/bloodhound
http://blood-hound.net
Blog ES: http://simelo-es.blogspot.com/
Blog EN: http://simelo-en.blogspot.com/
Featured article:
--
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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
