I am generating a column chart where data is fetched using ajax on the
basis of customers selected. i.e. if customers A and B are selected then
the data fetched will be of type:
Date A B
2014/12/13 23.4 43
2014/12/12 33.5 33.5
2014/01/23 33.4 55.6
2014/01/12 112 45.6
Similarly, if customers A B C D are selected the data fetched will be like
Date A B C D
2014/12/13 23.4 43 22 334
2014/12/12 33.5 33.5 33 44
2014/01/23 33.4 55.6 55 54
2014/01/12 112 45.6 33 33
Now this data is then grouped on months and on clicking a button chart is
generated.
Problem is that i have to write separate code for grouping for every number
of customers selected--
if (noOfCustomers == 1) {
result = google.visualization.data.group(
data,
[{ column: 0, modifier: getMonths, type: 'date'}],
[{ 'column': 1, 'aggregation':
google.visualization.data.sum, 'type': 'number'}]
);
}
else if (noOfCustomers == 2) {
result = google.visualization.data.group(
data,
[{ column: 0, modifier: getMonths, type: 'date'}],
[{ 'column': 1, 'aggregation':
google.visualization.data.sum, 'type': 'number' }, { 'column': 2,
'aggregation': google.visualization.data.sum, 'type': 'number'}]
);
}
else if (noOfCustomers == 3) {
result = google.visualization.data.group(
data,
[{ column: 0, modifier: getMonths, type: 'date'}],
[{ 'column': 1, 'aggregation':
google.visualization.data.sum, 'type': 'number' }, { 'column': 2,
'aggregation': google.visualization.data.sum, 'type': 'number' }, {
'column': 3, 'aggregation': google.visualization.data.sum, 'type':
'number'}]
);
}
else if (noOfCustomers == 4) {
result = google.visualization.data.group(
data,
[{ column: 0, modifier: getMonths, type: 'date'}],
[{ 'column': 1, 'aggregation':
google.visualization.data.sum, 'type': 'number' }, { 'column': 2,
'aggregation': google.visualization.data.sum, 'type': 'number' }, {
'column': 3, 'aggregation': google.visualization.data.sum, 'type': 'number'
}, { 'column': 4, 'aggregation': google.visualization.data.sum, 'type':
'number'}]
);
}
return result;
[{ 'column': 1, 'aggregation': google.visualization.data.sum, 'type':
'number'}] only because of change in this piece of code i have to repeat
the entire code for data grouping.
Is there a way where i can like use a loop where the code for grouping will
be generated according to noOfCustomers selected?
--
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/d/optout.
