Hmm...the Group function may not have been updated to handle column roles.
No problem - it just takes one extra step: after grouping the data, use
the #setColumnProperty method to set the column's role:
// set the fifth column to the 'tooltip' role
groupedData.setColumnProperty(4, 'role', 'tooltip');
On Wednesday, August 15, 2012 8:00:47 PM UTC-4, API Developer wrote:
>
> That's great!
>
> Are you sure the role: 'tooltip' works? I tried that and haven't been
> getting back the correct column when I do the group...
>
> On Wednesday, August 15, 2012 3:59:27 PM UTC-4, asgallant wrote:
>>
>> Yes, grouping works with column roles. If the role column is part of the
>> group, you just need to use the column number. If it is one of the columns
>> being grouped, you need to add role: 'tooltip' to the column map, ie:
>>
>> {column: 4, aggregation: function(ar) { return ar.join('\n') } , type:
>> 'string' , role: 'tooltip'},
>>
>> On Wednesday, August 15, 2012 3:14:55 PM UTC-4, API Developer wrote:
>>>
>>> I was thinking about doing something like this:
>>>
>>> function drawJoin() {
>>> var dt = google.visualization.arrayToDataTable([
>>> ['Department Number', 'First Name', 'Last Name', 'Sales'],
>>> [1, 'john', 'doe', 10],
>>> [1, 'jane', 'doe', 100],
>>> [3, 'jill', 'jones', 50],
>>> [3, 'jack', 'janes', 75],
>>> [5, 'al', 'weisenheimer', 500]
>>> ]);
>>>
>>> // Group dt by column 0, and show column 3 aggregated by sum.
>>> var grouped_dt = google.visualization.data.group(
>>> dt, [0, 2],
>>> [
>>> {'column': 1, 'aggregation': function(ar) { return ar.toString() }
>>> , 'type': 'string'},
>>> {'column': 3, 'aggregation': google.visualization.data.sum, 'type'
>>> : 'number'}
>>> ]);
>>>
>>>
>>> var table = new google.visualization.Table(document.getElementById(
>>> 'table'));
>>> table.draw(dt, null);
>>>
>>> var grouped_table = new google.visualization.Table(document.
>>> getElementById('grouped_table'));
>>> grouped_table.draw(grouped_dt, null);
>>> }
>>>
>>> Will this sort of thing work if I have tooltips/things with roles? Do I
>>> process them like all the other columns?
>>>
>>> On Tuesday, August 14, 2012 10:55:40 PM UTC-4, asgallant wrote:
>>>>
>>>> You can group by any column you want. What would you like the
>>>> dataTable to look like after grouping? Alternatively, what do you want to
>>>> do with the grouped data?
>>>>
>>>> On Tuesday, August 14, 2012 9:05:32 PM UTC-4, API Developer wrote:
>>>>>
>>>>> Hey guys,
>>>>>
>>>>> Do you know if it's possible to keep the domain the same if you want
>>>>> to group based off another variable entirely?
>>>>> My data looks like this:
>>>>> var data = google.visualization.arrayToDataTable([
>>>>> ['ID', 'Life Expectancy', 'Fertility Rate', 'Region',
>>>>> 'Population'],
>>>>> ['CAN', 80.66, 1.67, 'North America',
>>>>> 33739900],
>>>>> ['DEU', 79.84, 1.36, 'Europe',
>>>>> 81902307],
>>>>> ['DNK', 78.6, 1.84, 'Europe',
>>>>> 5523095],
>>>>> ['EGY', 72.73, 2.78, 'Middle East',
>>>>> 79716203],
>>>>> ['GBR', 80.05, 2, 'Europe',
>>>>> 61801570],
>>>>> ['IRN', 72.49, 1.7, 'Middle East',
>>>>> 73137148],
>>>>> ['IRQ', 68.09, 4.77, 'Middle East',
>>>>> 31090763],
>>>>> ['ISR', 81.55, 2.96, 'Middle East',
>>>>> 7485600],
>>>>> ['RUS', 68.6, 1.54, 'Europe',
>>>>> 141850000],
>>>>> ['USA', 78.09, 2.05, 'North America',
>>>>> 307007000]
>>>>> ]);
>>>>>
>>>>> I want to do a group on Region, is this possible.
>>>>>
>>>>> If not, is there anything I can do so I can keep a list of the ID's
>>>>> that would go under the region?
>>>>> --My plan would be to make it so it shows in the tooltips
>>>>>
>>>>
--
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/-/K1UPim_Wa5IJ.
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.
