asgallant:
Thank You!!!! I changed "group" to lowercase and the code worked perfectly.
Mark.
On Monday, December 3, 2012 12:10:00 AM UTC-5, asgallant wrote:
> Oops, "Group" shouldn't be capitalized there. It should be
>
> var counts = google.visualization.data.group(data, [0], [{
> column: 0,
> type: 'number',
> label: 'Count',
> aggregation: google.visualization.data.count
> }]);
>
> On Sunday, December 2, 2012 12:36:17 PM UTC-5, Coltrane wrote:
>>
>> asgallant:
>>
>> I've tried applying your code with no luck. I've reviewed the group
>> documentation and here's what I'm doing:
>> creating datatable and populating it with my source data:
>>
>> var data = new google.visualization.DataTable();
>> data.addColumn('string', 'Workflow Stage');
>> data.addColumn('string', 'Project Name');
>>
>> then I add the source data:
>>
>>
>>
>> data.addRows([[currentEmplyee.get_item("WFStage"),currentEmplyee.get_item("Project_x0020_Name")]]);
>>
>> I add your code for the creation of the new datatable with an input of
>> the data table I created with my source table:
>>
>> var counts = google.visualization.data.Group(data, [0], [{column: 0,
>> type: 'number', label: 'Count',aggregation:
>> google.visualization.data.count}]);
>>
>> get my html element:
>>
>> var table = new
>> google.visualization.Table(document.getElementById('table_div'));
>>
>> now draw my table:
>>
>> table.draw(counts, {allowHtml: true,showRowNumber: true});
>>
>> my code executes correctly until it reaches the "var counts" line.
>>
>> no table is drawn. What am I doing wrong??
>>
>> Thanks in advance.
>>
>> Mark
>>
>> On Monday, April 23, 2012 3:17:04 PM UTC-4, asgallant wrote:
>>
>>> Example code might help. This groups by column 0 in the DataTable and
>>> outputs a DataTable with distinct entries in column 0 and the count in
>>> column 1:
>>>
>>> var counts = google.visualization.data.Group(data, [0], [{
>>> column: 0,
>>> type: 'number',
>>> label: 'Count',
>>> aggregation: google.visualization.data.count
>>> }]);
>>>
>>> On Monday, April 23, 2012 3:09:01 PM UTC-4, asgallant wrote:
>>>>
>>>> I can't speak to using Sharepoint as a data source, but you if I
>>>> understand what you want correctly, you could use the Viz API's built in
>>>> Group<https://developers.google.com/chart/interactive/docs/reference#google_visualization_data_group>function
>>>> to get totals.
>>>>
>>>> On Monday, April 23, 2012 2:59:35 PM UTC-4, Coltrane wrote:
>>>>>
>>>>> Folks:
>>>>> I attempting to use a SharePoint list as the source for bar graph and
>>>>> in the the client side query language that I must use (caml) does not
>>>>> support the count function. Does anyone know of another manner to
>>>>> query the SP list as the graph datasource to gain category totals?
>>>>>
>>>>> Thanks in advance.
>>>>>
>>>>> Mark
>>>>
>>>>
--
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/-/RfBT92p0XjoJ.
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.
