Thanks for the quick response. The problem is that the 2 gauges are not showing up, although the geoMap and filters seem to work. Here is the dashboard with code for the gauges included: http://www.aml360.com/testDashboard.html. The gauges are supposed to show up in the gray column on the left, stacked on top of each other. Ideally the gauges will show averages for entire dataset, and then update when either a filter is applied, or a region on the geoMap is clicked.
Again, greatly appreciate all the help! -John On Thursday, November 15, 2012 5:30:00 PM UTC+13, asgallant wrote: > > What is the problem you are seeing? Skimming that code, it looks like you > should get two gauges with values equal to the average of column 0 and > column 2. The only oddity that I see off the bat is the column 2 average > is getting labeled with the column 1 label. > > On Wednesday, November 14, 2012 9:37:25 PM UTC-5, John Rudolph wrote: >> >> Still pretty new to visualizations. I have created this geochart with a >> couple of category filters: http://www.aml360.com/testDashboard.html. I >> am trying to add a couple of gauges based on columns 0 and 2 in the >> imbedded table. Tried to do the best I could by looking at some prior forum >> posts, but still don't quite have the savy to make it work for my data. >> Below is as far as I made it with the gauges. Where did I slip up? Thanks >> in advance for the help. I'm always blown away by the great responses on >> this forum. >> >> // set up a dataTable for the gauges >> var gaugeData = new google.visualization.DataTable(); >> gaugeData.addColumn('string', 'Series'); >> gaugeData.addColumn('number', 'Average'); >> >> gauges = new google.visualization.ChartWrapper({ >> chartType: 'Gauge', >> dataTable: gaugeData, >> containerId: 'gauges', >> options: { >> redFrom: 100, >> redTo: 150, >> yellowFrom: 50, >> yellowTo: 100, >> minorTicks: 25 >> } >> }); >> >> google.visualization.events.addListener(gauges, 'ready', onReady); >> >> function onReady() { >> } >> >> // set up event listener to draw the gauge when the dashboard is done >> google.visualization.events.addListener(dashboard, 'ready', function >> (e) { >> var view = geoChart.getDataTable(); >> var group = google.visualization.data.group(view, [{ >> column: 1, >> type: 'string', >> modifier: function () { >> // make them all the same for grouping >> return 0; >> } >> }], [{ >> column: 0, >> type: 'number', >> label: view.getColumnLabel(0), >> aggregation: google.visualization.data.avg >> }, { >> column: 2, >> type: 'number', >> label: view.getColumnLabel(1), >> aggregation: google.visualization.data.avg >> }]); >> >> // clear the gaugeData table >> if (gaugeData.getNumberOfRows() > 0) { >> gaugeData.removeRows(0, gaugeData.getNumberOfRows()); >> } >> // populate the gaugeData table >> for (var i = 1; i < group.getNumberOfColumns(); i++) { >> gaugeData.addRow([group.getColumnLabel(i), group.getValue(0, >> i)]); >> } >> gauges.draw(); >> }); >> > -- 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/-/cwTmsMapHbwJ. 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.
