This may be one option - In Tableau Desktop select two Dimension fields (hold down CTRL key to select multiple). Right-click and select Combine Fields from context sensitive pop-up menu. This creates a new field combined from two existing and combined field can now be used as Quick Filter.
Curtis, it will be a little tricky to set up at first because you have to get all the Partitioning and Addressing set correctly, but with three 'simple' table calculations you can get the normal quick filter to behave as an AND filter rather than an OR filter. Here are the three table calculations:
WINDOW_MAX( TOTAL(COUNTD([Skills])) )
[WIN_SUM CNTD Skills]=[WIN_MAX TOTAL CNTD Skills]
(See attached.) Let me know if you have questions. Also if you post a packaged workbook with some sample (dummy) data with your data structure, I'll be happy to set it up for you.
Hope this helps,
Has All Skills.twbx.zip 387.7 KB
Thank you Shawn. this is exactly what I was looking for and I think will solve my problem. Let me do a little experimenting and If I run into any problems, I'll beseech your help once again and send along a packaged workbook for you to take a look at.
Again, thanks for the help!
Thanks Eric for the assistance. I did not know this capability existed and I can certainly see how I could use Combine Fields option for other challenges I have encountered. However, this approach will not solve this specific problem I am trying to resolve.
Thanks for the additional insight into more of Tableau's capabilities. This application never ceases to amaze me.
A couple of simplifications for performance:
The addressing of the WINDOW_MAX(TOTAL(COUNTD(Skills))) is on the entire table, so that returns the same result as TOTAL(COUNTD(Skills)). For this view, you could just use TOTAL(COUNTD(Skills)), and possibly for other views as well.
Because Skills is in the level of detail of the view, COUNTD(Skills) will return 1. So WINDOW_SUM(COUNTD([Skills])) returns the same value as SIZE() or WINDOW_SUM(MIN(1)), both of which should be faster than a bunch of COUNTDs.
Right you are. It's one of those thing where you start heading down one path and once you get it working you forget to circle back around and do the simplify thing.
Curtis was able to get everything working except I forgot to mention the filter shelf snag: he had too many skills checked when he dragged the T/F field to the filter shelf so his only choice was false, so instead he chose 'Use All' thinking that would work. I mention this because it's a common error/misunderstanding that I too struggled with in the beginning.
Tip: When you drag the field to the filter shelf make sure you get a choice of both True and False (and pick true). If you only have False, then turn off some of the filters until you get both.
Curtis I created this new thread for your follow up question about displaying COUNTD() of IDs on a map. I couldn't remember how your real data was set up, so if you could explain why the IDs (Badge IDs) have duplications within a country and aren't aggregated together that would help. Also anything else about the differences between your real data and the superstore substitute I set up would be helpful.