Hi
I have data which contains the the name of an office, the staff name,
and a count
data = new google.visualization.DataTable();
data.addColumn('string', 'Staff Name');
data.addColumn('number', 'Count');
data.addColumn('string', 'Office');
data.addRows([
['Jon', 15,'London'],
['Kev', 29, 'London'],
['Dave', 4, 'Edinburgh'],
['Rosie', 11, 'Edinburgh'],
['Kim', 6, 'Cardiff']
]);
var table = new
google.visualization.Table(document.getElementById('table_div'));
var result = google.visualization.data.group(data, [2], [
{ 'column': 1, 'aggregation':
google.visualization.data.sum, 'type': 'number' }
]);
Now what I want to do is group by the office, which the code above
does but under each office I want to display the names and individual
counts of the staff. Is this possible and how do I go about it?
cheers
Jon
--
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.
