The only thing that sticks out to me is that you shouldn't use the "new"
keyword with google.visualization.data.group; this line:
var pcesmydata = new google.visualization.data.group(tmpdata,[1],[{'column':
2,'aggregation':google.visualization.data.sum, 'type':'number'}]);
should be:
var pcesmydata = google.visualization.data.group(tmpdata,[1],[{'column':
2,'aggregation':google.visualization.data.sum, 'type':'number'}]);
If that doesn't fix the problem for you, could you post a sample object to
pass to the drawPCEstate function so I can test this?
On Tuesday, March 12, 2013 9:19:11 AM UTC-4, SJA wrote:
>
> Hi
>
> I have written a dashboards of sorts, but one that uses a trick I found
> (attributable to asgallant, I think), which allows me to present some
> charts based on a hidden underlying dashboard/datatable.
>
> I'm having an issue with it though, in that the piechart doesn't draw on
> first load of the page, but works fine when a value is selected from the
> CategoryFilter or equally, when selections are removed from that (in effect
> reverting to the initial load state). Instead, I get an "e is null" error.
>
> Can anyone offer pointers as to what I'm doing wrong?
>
> function drawPCEstate(json) {
>
> var data = new google.visualization.DataTable(json.d);
>
> // holds the full data, including the column it will be filtered by
> var pceplacebo = new google.visualization.ChartWrapper({
> 'chartType': 'Table',
> 'containerId': 'placeboPCE',
> 'dataTable':data,
> 'view': {
> 'rows':[0]
> }
> });
>
> // table to present the summarised pceplacebo data
> var pcetable = new google.visualization.ChartWrapper({
> 'chartType': 'Table',
> 'containerId': 'config_PCEstate_table',
> 'options': {
> 'fontName': '"Arial"',
> 'fontSize': "10pt",
> 'chartArea' : {'width':'100%'}
> }
> });
>
> // chart to present the summarised pceplacebo data
> var pcechart = new google.visualization.ChartWrapper({
> 'chartType': 'PieChart',
> 'containerId': 'config_PCEstate_chart',
> 'options': {
> 'fontName': '"Arial"',
> 'fontSize': "10pt",
> 'chartArea' : {'width':'100%'}
> }
> });
>
> // categoryfilter
> var pcefilterdept = new google.visualization.ControlWrapper({
> 'controlType': 'CategoryFilter',
> 'containerId': 'pce_dept_filter',
> 'options': {
> 'filterColumnLabel': 'Department',
> 'ui': {
> 'label': 'Department',
> 'labelSeparator': ':',
> 'labelStacking': 'vertical',
> 'allowTyping': false,
> 'allowMultiple': true
> }
> }
> });
>
> //populate dashboard and bind filter to pceplacebo
> var pcedashboard = new
> google.visualization.Dashboard(document.getElementById('config_PCestate')).bind(pcefilterdept,pceplacebo);
> google.visualization.events.addListener(pcefilterdept, 'statechange',
> pceSummary);
> google.visualization.events.addListener(pcedashboard, 'ready',
> pceSummary);
> pcedashboard.draw(data);
>
> function pceSummary() {
> // build summary table for the current filter
> var tmpdata = pceplacebo.getDataTable();
> var pcesmydata = new
> google.visualization.data.group(tmpdata,[1],[{'column':2,'aggregation':google.visualization.data.sum,
>
> 'type':'number'}]);
> pcesmydata.sort([{'column':0, 'desc': false}]);
>
> // ensure consistent colouring on the pieChart - build array of
> colours one for each 'type' in the current selection
> var counter = 0;
> var pieColours = new Array();
> for (var i=0;i < pcesmydata.getNumberOfRows(); i++) {
> var valItem = pcesmydata.getValue(i,0);
> if (valItem == 'Win 7') {
> pieColours[counter] = constGreenA;
> } else if (valItem == 'Win XP') {
> pieColours[counter] = constRedA;
> } else if (valItem == 'Win XP legacy') {
> pieColours[counter] = constAmberA;
> } else {
> pieColours[counter] = constGreyA;
> }
> counter++;
> }
>
> pcetable.setDataTable(pcesmydata);
> pcetable.draw();
> pcechart.setDataTable(pcesmydata);
> pcechart.setOption('colors',pieColours);
> pcechart.draw();
> }
> }
> Thanks.
>
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
