Would you want the 20th excluded as well since there is no value under "Other" on the 20th?
Since I don't have a workbook to deal with, I can give some rough ideas of what I would do here. I am assuming that you are displaying the values as SUM([something]).
You can have a calc:
If ISNULL(SUM([something])) then 1 END
Then you can have another calc:
[Any Null values?]
If WINDOW_SUM([Null Value?]) > 0 THEN 1 else 0 END
You may have to mess with the direction that table calc runs. You want to calc it for each date.
Put that last calc on your filter shelf and select for value = 1. You will not display any dates that have at least one null. And this will work no matter how many groups you have.
There are different option to hide nulls, but this option may work best for you.
1. Right click on your 'Group A' pill
2. Click on Filter
3. Select Special
4. Check off Non-Null values
See the link below for a more detailed explanation:
Hope this helps
Thanks Joe and Don for trying to help
I believe Joe's solution is what i was looking for but I still can't quite get it to work properly. I tried Don's solution as well but there is no Customer A pill as Customer A is part of the larger Customer Group pill.
I attach a Tableau file here if someone could have a look. Appreciate any help on this!
I think the main issue is, is that you're trying to remove nulls from both columns.
When one column has a value and the other doesn't, you're not going to be able to remove the null without affecting the value in the other column that's on the same row.
By moving the Customer Group from the columns shelf to the rows shelf, the nulls will be automatically removed.
Not sure if this is what you were really going for, but it does the trick.
this will do the trick if i can then remove 11, 14 and 20 of jan as only one out of two customers has got a value on those dates. Someone suggested i can try to pad the data and let you know if it works this way
1 of 1 people found this helpful
I just read your original post...and here's your answer...
Create 2 new pills:
Double click on the 'A' pill (or 'Other') so it ends up on the Measure Values shelf.
Right click on both new pills (or use drop down arrow).
Then check off 'Non-null values' (for both pills).
There you have it:
lol...I must have been trying to over think it.
Hope this helps
Don, you'are a star, this worked! Thanks everyone for trying to help!