Rather than going the SETS route, you may want to try GROUPS. A simple calculation can control if your columns are displayed in groups or individual ACE scores.
You data, however, perplexed me. Are you able to reformat it so you have only integers?
I don't want to group them, actually. In the Workbook I attached, if you look at the filter options, it's pretty much how I want people to be able to interact with it. They can select the "ACEs Grouped" option to compare those with 0 ACEs to those with 1 or more. Or they can select the "Individual ACE Score" option, to compare the educational achievement of people with each ACE score (0,1,2,3 or 4).
The problem is the "0 ACEs" option isn't showing up in that latter filter.
I assume it's because in creating a set, it can't be in two sets at the same time.
That's what I want to figure out how to correct.
Is there a reason you prefer not to group them?
I was able to get this functioning (at least it looks like it) in 4-5 steps, but one of those is creating a GROUP.
I was able to get this to work without a group, too:
- Start by making a [Selector] parameter (0=Group, 1=Individual)
- Use your existing sets
- Create a calc:
STR(if [Selector]="0" then [ACEs Grouped]
else [Individual ACE scores]
- I changed this calc from T/F into a string before dropping it on Filters and choosing only T values
I'm uncertain if the internal calculations are accurate,m because without grouping, your sets aren't aggregating.
Hope this is food for thought. --Michael
I might have confused you, and am sorry! I already have the data grouped as "1 or more" in the original data base. So I'm not having to manipulate the data in Tableau to get there. That is something I should have been more clear about!!
Thank you so much for your attention to this.
I just figured it out thanks to your help. Parameter + Calculated field was the answer.