Hi All,
As the title reads, I simply would like to filter my rows based on specific values on the different columns, for example see table below:
ID | Col A | Col B | Col C | Col D |
1 | null | 0-0-0 | null | 2001-12-01 |
2 | null | 0-0-0 | 1998-11-07 | Null |
3 | 0-0-0 | 0-0-0 | null | 2004-11-05 |
4 | null | 2004-05-02 | 0-0-0 | 0-0-0 |
5 | null | null | 0-0-0 | null |
6 | null | null | null | 2002-05-08 |
7 | 0-0-0 | null | 0-0-0 | 0-0-0 |
8 | 2000-10-08 | null | 0-0-0 | 2010-12-05 |
9 | 2003-04-15 | null | 0-0-0 | 2007-02-06 |
10 | 0-0-0 | 0-0-0 | null | 2005-01-12 |
I need to filter to only show rows where Cold D has a date (i.e. NOT null or 0-0-0) AND Col A, Col B,Col C are null OR 0-0-0.
So table above should filter to only rows: 1,3,6,10
Is this possible?
Thanks
You could create a calculated field and then filter based on the result of the formula:
Create "Filter Formula 1" as
IF IFNULL([Col D] ,'0-0-0') <> '0-0-0'
AND IFNULL([ColA],'') <> ''
AND IFNULL([ColB],'') <> ''
AND IFNULL([ColC],'') <> ''
THEN 'Show'
ELSE 'Hide'
END
Then filter on your calculated field to display 'Show' only.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.