The goal here is to have it filter on all columns except for the first column the X-axis column (in this case date)
Perhaps this will help. Image you are in heading the analytics department for a major car company. You have 4 major stores that depend on you for adjusted sales data. (Only corporate knows how many cars are really sold because consumers can return cars at any store). Store 1 sales all models Store 2 Sales only Models A,B,C Store 3 Sales Models B,D,E,F Store 4 Sales Models A,C,E So the goal here is to create a visualization that will display dynamic amounts of information since not all stores are interested the same data. Some stores are interested in only certain models and couldn't care less about the remaining models. To create a static chart you must format the data with the sales by models in additional columns (See sheet Standard Format).Column A: Month, Column B: Model A Sales, Column C: Model B Sales, Column D: Model C Sales etc.. This accomplishes exactly what we would need if we were presenting to the CEO however, this chart is for store managers who are interested in breaking apart the data further. In excel, to accomplish the goal I would change the format of the data (See sheet Modified Format). Column A: Month, Column B: Model, Column C: Sales. I could then apply a filter to column B and dynamically control the chart based on model. In my initial post I tried to replicate this but was unable to as google script - Charts didn't support this data format (Modified Format). The other possible solution is for a column data filter where I could dynamically select which columns of data to include (Standard Format). I hope that I have illustrated a simple version of what I'm trying to accomplish. We have discussed earlier about created a simple dialog box that could work to statically filter out certain columns of data before the chart was rendered but that I feel defeats the power of google dashboards. On Tuesday, July 16, 2013 8:27:10 PM UTC-7, asgallant wrote: > > Could you clarify how you would want that to work? Do you want to be able > to filter on multiple columns with a single control? > > On Tuesday, July 16, 2013 11:15:46 PM UTC-4, Ryan wrote: >> >> Upon further reflections. My request could be simplified to >> >> Filters that work with Columns as opposed to Rows. >> > -- 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/groups/opt_out.
NeedForColumnFilter.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
