I think you should add a view to the ScatterChart's ChartWrapper object. You still pass the whole DataTable to Dashboard#draw(). Have a look at
https://developers.google.com/chart/interactive/docs/gallery/controls#create_controls It's kind of long, but it contains an example of setting a view in a ChartWrapper. (It's not exactly the same as creating a DataView object.) Hope that helps, let me know if you have further questions. MC Get Vizzy ---------- Forwarded message ---------- From: AnnaBrown <[email protected]> Date: Sat, May 26, 2012 at 4:02 AM Subject: [visualization-api] Dashboard - using CategoryPicker control on a column that isn't drawn To: Google Visualization API <[email protected]> I'm using a the Query object to return a three columns of a table from a google spreadsheet. The first column is a label column, the 2nd and 3rd data values. I'm trying to create a dashboard binding a CategoryPicker control object and a ControlWrapper (ScatterChart) object. I'd like to use the Category Picker as a means of filtering the rows within the data (by selecting the row labels in the first or label column) and then have the remaining two columns of data drawn within the scatter chart. I am knew to this API and I am struggling with how to concurrently allow the CategoryPicker to work and exclude the label column from the ScatterPlot ControlWrapper object. I've tried using a DataView to limit the Queried data view to the 2nd and 3rd columns, but I believe the Dashboard object binding method needs all three columns to support the CategoryPicker's function. What's the appropriate way to go about achieving this outcome? Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. 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. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. 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.
