-
1. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Joe OppeltJan 28, 2019 8:44 AM (in response to Micheal Nadar)
Quick filter deletes the unselected values from the underlying table. You no longer have visibility to them, so you won't get the "other" data you want.
Look at SET ACTIONS (starting in V 2018.2 or 2018.3, not sure which one...) This lets your user select multiple values, and then you build calcs using the set's IN/OUT capability. All the "out" values would be your "other" value.
There are a bunch of Tableau KB articles and how-to videos on Set Actions, so I recommend you check them out. I haven't done a lot with them yet, so I'm not the guy to guide you on best practices for them.
-
2. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Micheal Nadar Jan 29, 2019 9:17 AM (in response to Joe Oppelt)Thanks Joe for your response and highlighting the new topics which could help me here.
We are still on 10.5.1 can't we try some workaround with features that we already have like data blending/sets/actions?
-
3. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Ken FlerlageJan 29, 2019 6:10 PM (in response to Micheal Nadar)
Okay, so this is a lot of work to get to your final solution, but I think I've figured out a way to do this. It's all pretty much just Tableau trickery.
First of all, we need union the data to itself, which will duplicate the data. Next, we'll use the new Table Name field to create an artificial Market name:
Market New
// Adjusted market name.
IF [Table Name]="Sheet1" THEN
[Market]
ELSE
[Region] + " Other"
END
Then we'll create calculated fields to get some additional details, ultimately getting to Amount New which will give us either the amount for the market or for "Other".
Total Amount
// Get the total overall amount for the region.
// Dividing by 2 to account for data duplication from the union.
{FIXED [Region]: SUM([Amount]/2)}
Other Amount
// Get the amount for "Other"
MAX([Total Amount])-SUM([Amount])
Amount New
// Amount depending on if it is a regular region or "Other"
IF RIGHT(ATTR([Market New]),5)="Other" THEN
[Other Amount]
ELSE
SUM([Amount])
END
Then we can build a view based on Market New and Amount New.
The trick here is that our filter is on Market and the union is handling the creation of the "Other" segment. You'll also want a filter on Amount New to include anything >0. Without this, the "Other" segment will always show even if all markets in that region are selected.
Take a look at it in action:
See attached.
-
Other_v10.5.twbx 24.3 KB
-
-
4. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Micheal Nadar Jan 30, 2019 12:31 PM (in response to Ken Flerlage)That was excellent - It worked
Appreciate you effort and thank you so much for this brilliant workaround.
-
5. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Ken FlerlageJan 30, 2019 3:47 PM (in response to Micheal Nadar)
Any time. Glad it worked!!
-
6. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
kumud.pandey Aug 19, 2019 8:50 AM (in response to Micheal Nadar)Thanks Ken Flerlage for sharing your work, it's great! I was wondering if there is any workaround without duplicating the data.
-
7. Re: Pie chart displaying "Selected" and "All Other" (un-selected) items from multiple selection quick filter
Ken FlerlageAug 19, 2019 9:13 AM (in response to kumud.pandey)
Not that I can think of...