-
1. Re: Dashboard action filter to drill through is not working
Joe OppeltSep 10, 2018 9:37 AM (in response to kate summer)
What are you trying to do in there with MIN({SUM([Sales])}) ?
That value is getting calc'd at the entire database level, regardless of the dimensions on the sheet. (2,297,201 is the number you get, no matter what subcategories you select.) -
2. Re: Dashboard action filter to drill through is not working
kate summer Sep 10, 2018 9:46 AM (in response to Joe Oppelt)I want to see the sales detail of whatever the UNSELECTED subcategories in the filter. Is there another way to display this?
-
3. Re: Dashboard action filter to drill through is not working
Joe OppeltSep 10, 2018 9:50 AM (in response to Joe Oppelt)
I think I see what you're trying to do.
The unselected sales bar is the sum of sales that the user has NOT selected in the filter on "Chart".
You can't pass a measure in an action filter. Only a dimension. And what gets passed (if anything) is what was selected, not the absence of a selection.
-
4. Re: Dashboard action filter to drill through is not working
Joe OppeltSep 10, 2018 9:51 AM (in response to kate summer)
It's going to take a hack, if it can be done at all.
Curious problem. I'm seeing if I can figure something out. -
5. Re: Dashboard action filter to drill through is not working
maneesh.gaddam Sep 10, 2018 9:55 AM (in response to kate summer)This gives you sales amount for the unselected categories
SUM({ FIXED : SUM([Sales])})-SUM([Sales])
But the drill-down doesn't work because
1) actions work on dimensions not measures
2) For unselected sales, there is no corresponding sub-category (as it wasn't selected in quick filter) to drill down the bottom grid.
Hope this makes sense
-
6. Re: Dashboard action filter to drill through is not working
kate summer Sep 10, 2018 10:03 AM (in response to maneesh.gaddam)Ok, that makes sense with the action.
Is there any other way to dynamically show what are not selected by the users?
-
7. Re: Dashboard action filter to drill through is not working
Shinichiro MurakamiSep 10, 2018 10:05 AM (in response to kate summer)
Hi Kate,
This is little bit tricky, and the final view is not very fancy. but still operation-able from my perspective.
(" Always show" needs to be selected always literally. ==> add "space" to the left of "Always" to keep top position o the filter. )
Thanks,
Shin
-
8. Re: Dashboard action filter to drill through is not working
Joe OppeltSep 10, 2018 10:29 AM (in response to Shinichiro Murakami)
Kate -- What I tried doing was messing with the action filter that gets added to the "Detail" sheet when I create an action that passes Sub-Category. You can do some things to that pill, and what I tried doing was changing it to an EXCLUDE filter once it got added to the "Detail" sheet.
On the first click it actually did what I wanted. I had the "Chart" sheet passing all the sub-catetgories that were selected, and the modified action filter set to EXCLUDE was actually showing everything that was NOT passed. However it seems Tableau doesn't like that. Once I cleared the filter, (by de-selecting what was clicked on the "Chart" sheet), it reset the action filter on "Detail" so that it stopped working.
Therefore, follow through with what Shin is doing in his reply. -
9. Re: Dashboard action filter to drill through is not working
kate summer Sep 10, 2018 11:32 AM (in response to Shinichiro Murakami)Hi Shin,
I think this is going to the right direction. But the sales for selected was doubled in the chart because the always show is selected.
Thank you for your help!
Kate
-
10. Re: Dashboard action filter to drill through is not working
Shinichiro MurakamiSep 10, 2018 11:38 AM (in response to kate summer)
Sorry my fault.
This filter should n't be the context.
If the posts helped, please mark answer as correct / helped to close the thread not from inbox but from original post.
Thanks,
Shin
-
11. Re: Dashboard action filter to drill through is not working
kate summer Sep 10, 2018 12:41 PM (in response to Shinichiro Murakami)Hi Shin,
Thank you so much! I have a followup question. If replacing the sum of sales by count distinct of city, how to show a list of cities that do not have sales in unselected sub-category? That is, if a city has any sales in any of the selected sub-category, that city is out.
Thanks again,
Kate
-
12. Re: Dashboard action filter to drill through is not working
Shinichiro MurakamiSep 10, 2018 1:07 PM (in response to kate summer)
HI Kate,
It's completely different, not follow up at all.
Please post new thread with clear expectations.
Thanks,
Shin