Forum Discussion
How to create parameters on many columns
Anonymous amitchandak
Hello,
Thanks for your answers.
I cannot do exactly what I want with the solutions suggested.
Let me rephrase the issue for more clarity.
There are 5 columns:
Program (Name of the TV show),
Duration (Length of the program in hours),
Country_1 (Boolean – TRUE() if the “Program” is broadcasted in the country otherwise FALSE()),
Country_2 (Boolean – TRUE() if the “Program” is broadcasted in the country otherwise FALSE()),
Country_3 (Boolean – TRUE() if the “Program” is broadcasted in the country otherwise FALSE()),
I would like to build a bar chart with “Program” as dimension and “Duration” as value.
I would like to be able to filter this bar chart based on a filter which contains ONLY those 4 options: Country_1 (keep all the shows display in country 1), Country_2 (keep all the shows display in country 2), Country_3 (keep all the shows display in country 3) and Keep all.
The tricky aspect is that the countries are not exclusive so Program_1 can be broadcasted in both Country_1 and Country_2. Where I am struggling is to build the filter on the bar chart.
Hope it’s clearer.
Let me know if you need any additional information,
Thanks for the help.