Thank you very very much! Worked perfectly!
On Tue, Sep 11, 2012 at 5:52 PM, asgallant <[email protected]>wrote:
> You can use the group function to sum columns in your DataTable, and then
> insert that total into your heading:
>
> // group the data table to get the sum of column 1
> var group = google.visualization.data.group(data, [{
> column: 0,
> type: 'number',
> // modify column 0 to return the same for all rows
> // so we can get the sum of everything in column 1
> modifier: function () {
> return 0;
> }
> }], [{
> // get the sum of column 1
> column: 1,
> type: 'number',
> aggregation: google.visualization.data.sum
> }]);
>
> var sum = group.getValue(0, 1);
> // put the sum wherever you need it
>
>
> On Tuesday, September 11, 2012 7:19:26 AM UTC-4, Wesley Chin wrote:
>>
>> Hi everyone,
>>
>> I have 2 working charts (a vertical bar and a pie chart) that are
>> displaying totals for me. I want to add up all the totals that are
>> displayed on each chart and put it into the heading, is that possible? I
>> have a div with the heading (I am using html, PHP and javascript) and would
>> like to put the total in it. How can I achieve that?
>>
>> Regards,
>> Wesley
>>
> --
> 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/-/RwjXWUUKn-0J.
>
> 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.
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
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.
