Hey asgallant,
Is there any way to get the information for what's currently being grouped
on? I'd like to be able to not just add the tooltips together, but add the
column information for what grouped it, so the user would get a better idea
of what they're seeing.
On Wednesday, August 15, 2012 11:03:00 PM UTC-4, asgallant wrote:
>
> 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/-/-L-ZjgX7hlkJ.
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.
