google.visualization.data.group

108 views
Skip to first unread message

Altran

unread,
Dec 5, 2012, 12:24:23 PM12/5/12
to Google Visualization API
Hi,

Is it possible to have a pie graph and a table controlled by a
NumberRangeFilter (column Date) and CategoryFilter (column Client)
with sum aggregation on column 'Number of Equipments' ?

I have grouped the data with the following but the records not get
grouped, as you can see in table below (I want only one record for the
key Pending/20121122/Altran).


//group the data for the pie chart
'dataTable' : google.visualization.data.group(data, [0, 1, 2],

[{'column': 3, 'aggregation': google.visualization.data.sum, 'type':
'number'}]),


State Date Client  Number of Equipments
Pending 20121122 Altran 1
Pending 20121122 Altran 1
Pending 20130115 Altran 2
Waiting 20121122 Altran 2
Confirmed 20101122 Teste 2
Confirmed 20121122 Altran 3
Rejected 20121122 Altran 2

Thanks,

asgallant

unread,
Dec 5, 2012, 12:33:19 PM12/5/12
to google-visua...@googlegroups.com
Are the other rows grouping properly, or are none of them grouping at all?  If it's just the Pending/20121122/Altran rows, then I would suggest looking at the source data to make sure they are actually the same (there could be whitespace in one of the strings, for instance).
Reply all
Reply to author
Forward
0 new messages