There are two options:
Option 1. Right-click on the null values and select Hide
Option 2. Follow the directions in this article: Filtering the View Without Filtering Underlying Data | Tableau Software
If you have any trouble and need some more help, the best thing you can do is post a sample packaged workbook that adequately demonstrates the issue.
Thanks Nick. I have used the hide null values option, but haven't figured out how to use table calculations for this problem.
Can you send out a sample packaged workbook that demonstrates the issue.
I'm not sure I quite get what is or is not working.
H Nick, I repost my question, with sample workbook attached. Could you please take a look? Thank you!
I have attached a sample workbook back that I think might resolve your question.
1. Create a string parameter (Department) and populate it with the values from Dept
2. Add an additional value called "No Dept"
3. Create a calculated field (Which Department): IFNULL([Dept],"No Dept")=[Department]
4. Add [Which Department] to the view.
5. Hide False Values
6. Right-click on [Department] in the parameters pane and select "show parameter control"
7. Remove [Dept] from the view and hide the header for [Which Department]
Filtering.twbx 15.3 KB
Thanks Nick! The solution is very neat! It helps with some dashboards, where showing one department is preferable.
For other dashboards, faculty/dept chairs would like to see all depts in the window then decide whether to select/filter to see only certain depts. If you think of a way to achieve this, please let me know. I will also continue to work on this problem.
Hi Ji Zhou
Do you mean this results?
You can add one more calc field for display filter which does no t filter underlying data, but only display.
Below table calculation allows that functions.
Filtering_SM_10.0.twbx 17.0 KB
That's exactly what I need! Thank you so much! This solution helps with most of my workbooks!
Could you please explain the code: lookup(min([Dept]),0). What does it do? Dept is a dimension. Can a dimension have minimum value?
1 of 1 people found this helpful
Yes, in dimension, min pick up alphabetical minimum.
however, min, max does not matter because only one data exist in one field.
The reason to put "min" is this function is available thru table calculation.
Table calculation requires same level of "aggregation data" and that 's why we need to add "min" or "max" to emulate dimension as value of table calculation.
"0' means referring same cell.
Got it. Thank you Shin.
You are very welcome.