3 Replies Latest reply on Jul 15, 2016 1:09 PM by Stephen Rizzo

Filtering out Nulls across multiple data points

Courtney Young Jul 15, 2016 12:08 PM

For the life of me, I cannot figure out how to do this. I've attached a workbook as an example. I would like to filter out all nulls but it's across multiple selections within one dimension. I want to see ONLY those IDs with quantity in all four events (Thursday, Friday, Saturday and Sunday). Right now, my table is showing accounts if they have any of those days. In the attached workbook, ID # 1515560 would be an example of what I would like to filter to. Any and all help is MUCH appreciated!

SampleWkbk_CBY.twbx 309.0 KB

1. Re: Filtering out Nulls across multiple data points

Stephen Rizzo Jul 15, 2016 12:44 PM (in response to Courtney Young)
You should be able to use a table calculation to calculate the number of events an ID is associated with, then filter on that variable. See attached. Is this what you were looking for?

SampleWkbk_CBY.twbx 316.7 KB
Like Show 0 Likes(0)

Actions
2. Re: Filtering out Nulls across multiple data points

Courtney Young Jul 15, 2016 1:02 PM (in response to Stephen Rizzo)

Hi Stephen,

I think this will give what I need - THANK YOU!! One follow up question, if you don't mind. Is there a way to bring back in the Grand Total? It's just showing as a blank now. Is there a calculation I can add for that? (please forgive my lack of knowledge when it comes to calculated fields).

Thanks again for your help!
Like Show 0 Likes(0)

Actions
3. Re: Filtering out Nulls across multiple data points

Stephen Rizzo Jul 15, 2016 1:09 PM (in response to Courtney Young)

Glad to help! The column grand totals don't appear blank for me. Maybe try disabling them and turning them back on? You can change which totals are displayed in the Analysis > Totals menu.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Filtering out Nulls across multiple data points

1. Re: Filtering out Nulls across multiple data points

2. Re: Filtering out Nulls across multiple data points

3. Re: Filtering out Nulls across multiple data points

Actions

More Like This