Hi Connor, There is a 'group' function that would help you aggregate the column into two values for the number of yes and no answers. See https://developers.google.com/chart/interactive/docs/reference#----group
But this can't be run within a Dashboard, so you would have to essentially build your own dashboard by creating the control, drawing it yourself, and handling events to then drive your custom aggregator. That's not going to be easy, but I can see that it would be a useful kind of functionality, so we'll have to think about how to make this easier. Maybe we could add a 'group' option to the 'view' for a ChartWrapper. On Sat, Jul 4, 2015 at 12:10 AM, Connor B <[email protected]> wrote: > Hello there! I have a DataTable that pulls data from a spreadsheet. You > can filter the data down via ControlWrapper and a Dashboard. I have a > column that contains either a YES or a NO and I would like to be able to > count all the times YES or NO appears and display the data in a pie chart. > The issue is that this counting of the occurrences of YES and NO must be > calculated after the filters are ran. I cannot figure out a way to do this, > is this possible? > > Thanks, > Connor Brewster > > -- > 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. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> - 978-394-1058 [email protected] <[email protected]> 5CC, Cambridge MA [email protected] <[email protected]> 9 Juniper Ridge Road, Acton MA -- 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.
