Thanks, that gave a partial solution. The table now shows but the pie is
not and i get the same error message. I tried every source column possible.
The tabel shows records from a ticket administration (ticketnumber,
datetime creation, ticket responsible, Title of ticket.
In the Pie i would like to show the total number of open tickets per
responsible.
Op vrijdag 10 oktober 2014 02:58:14 UTC+2 schreef Andrew Gallant:
> Your aggregation column needs to be a number type:
>
> var GroupedData = google.visualization.data.group(Data,[2],[{
> column: 2,
> type: 'number',
> label: Data.getColumnLabel(2),
> aggregation: google.visualization.data.count
> }]);
>
> You may need to change the source column to something other than 2, since
> that is what you are grouping by, but I may be thinking of a different use
> case.
>
> On Thursday, October 9, 2014 2:52:27 AM UTC-4, [email protected] wrote:
>>
>> Hi,
>>
>> I have a table with some data and from that data I would like to count
>> the number of records for column 'Verantwoordelijke'
>> The result I would like to show in a pie chart under the table.
>> My idea was to group the data on that column and use the count to get
>> those numbers
>> If i run the code I get an error:
>> +++++++++++++++
>> Foutdetails webpagina
>> Gebruikersagent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1;
>> WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR
>> 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; .NET CLR 1.1.4322;
>> InfoPath.3)
>> Tijdstempel: Thu, 9 Oct 2014 06:48:09 UTC
>>
>> Bericht: Script error
>> Regel: 0
>> Teken: 0
>> Code: 0
>> URI:
>> https://www.google.com/uds/api/visualization/1.0/dee027d0b48a2e0a0a0375d00d7dd635/format+nl,default+nl,ui+nl,corechart+nl.I.js
>> +++++++++++++++
>> If I remove the code for the groupeddata the table shows normal.
>>
>> I am sure I am overlooking something. I read the documentation but the
>> solution has not dawned yet.
>> Does anyone have a suggestion?
>> The code I have now is:
>>
>>
>> <!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Strict//EN' '
>> http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd'><html xmlns='
>> http://www.w3.org/1999/xhtml' xml:lang='nl' lang='nl'>
>> <html><head><title>Monitor</title>
>> <meta http-equiv="Content-Type"content="text/html; charset=utf-8">
>>
>> <script type='text/javascript' src='https://www.google.com/jsapi
>> '></script>
>> <script type='text/javascript'>
>> google.load('visualization', '1', {packages:['corechart']});
>> google.setOnLoadCallback(drawStuff);
>>
>> function drawStuff() {
>> var Data = new google.visualization.DataTable();
>> Data.addColumn('string', 'Nummer');
>> Data.addColumn('string', 'Datum');
>> Data.addColumn('string', 'Verantwoordelijke');
>> Data.addColumn('string', 'Titel');
>> Data.addRows([
>> ['189646','08-08-2014 12:42:58','Ine Bastings','Record nummer
>> 1'],
>> ['190002','12-08-2014 14:40:07','Ine Bastings','Record nummer
>> 2'],
>> ['191870','01-09-2014 09:02:40','Ine Bastings','Record nummer
>> 3'],
>> ['192327','03-09-2014 13:41:33','Patrick van der
>> Linden','Record nummer 4'],
>> ['193141','12-09-2014 14:40:47','Barbera de Graaf','Record
>> nummer 5'],
>> ['193235','15-09-2014 12:49:44','Barbera de Graaf','Record
>> nummer 6'],
>> ['192333','03-09-2014 14:03:36','Patrick van der
>> Linden','Record nummer 7'],
>> ['192542','05-09-2014 12:57:21','Patrick van der
>> Linden','Record nummer 8'],
>> ['192328','03-09-2014 13:49:00','Patrick van der
>> Linden','Record nummer 9'],
>> ['193243','15-09-2014 13:13:01','Barbera de Graaf','Record
>> nummer 10']
>> ]);
>> var GroupedData = google.visualization.data.group(Data,[2],[{
>> column: 2,
>> type: 'string',
>> label: Data.getColumnLabel(2),
>> aggregation: google.visualization.data.count
>> }]);
>> var Pieview = new google.visualization.DataView(GroupedData);
>> Pieview.setColumns([1,0]);
>>
>> var table = new
>> google.visualization.Table(document.getElementById('table_div'));
>> table.draw(Data, {showRowNumber: false,width: '300',allowHtml:
>> true});
>> var Piechart = new
>> google.visualization.PieChart(document.getElementById('pie_div'));
>> Piechart.draw(Pieview);
>> }
>>
>> </script>
>> </head>
>> <body>
>> <div id='table_div' style='width: 1200px;'></div>
>> <div id='piechart_div' style='width: 1200px; height: 500px;'></div>
>>
>> <a href=monitor.html>Terug naar hoofdscherm van monitor</a>
>> </body></html>
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
