Done and done :D
On Thursday, August 16, 2012 1:46:16 PM UTC-4, asgallant wrote:
>
> You can add any extra info you want. The aggregation function takes an
> array of data and outputs a single data value, which can be anything (as
> long as it conforms to the data type specified), so if you want to add any
> extra data to the tooltip, go right ahead.
>
> On Thursday, August 16, 2012 12:14:48 PM UTC-4, API Developer wrote:
>>
>> 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/-/8COJ_N5_0lwJ.
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.
