If you create your filter on the addition of your different 0/1 columns and filter on anything of at least 1 would that work?
It would probably be easier to demo if you have an example of data to play with.
(doesnt have to be real data, but real structure)
Tableau lets you create multiple visuals (worksheets) and combine them into one or more dashboard displays. A click on one visual can be used to filter information on the others.
I work for a school district. If my display shows schools across the district, I can provide many drop-down or selection filters to the user to select which schools and criteria they want and the visuals change accordingly. If I provide a chart or map with many numbers and names...clicking one can filter other areas of my display based on what was clicked. In this way, I can allow the user to change things like race, grade, gender, etc and the dashboard information changes accordingly. It would be no different if my data were sales or clinical data.
As with anything, there is a learning curve with Tableau. I have a few months experience with Tableau as well as programming background with Excel, VBA, etc. My other monitor has Tableau on it currently...not Visual Studio.
Yes, that would somewhat work with the added complexity that it would need to be a sum of 1 only for the products they selected (out of a total of 9 different products).
So it would look like the following for the filter:
with check boxes next to each one, and if I selected Product 1 and Product 3, I would pull up any rows that have a 1 in either Product 1 OR Product 3.
Could you attach a packaged workbook instead? Without data, you cannot really open it.
(sorry should have asked)
I have an example, though I'm not entirely sure if this suits the purpose correctly. The reason for that is that you need a parameter for each product, which is a bit of a pain I think. I'll have a further think if it can be easier, but at least this is a possiblity and it works correct as far as I can see.
Have a look and see what you think.
I have one calculated field that sees if the parameter is selected and the product is in the trial and if so, counts it as 1.
Then I filter on that field to show all records with at least 1.
Hope this helps!