Even though it sounds simple,but its a nostalgia for me.
Let me explain you the requirement.I have the data like the one below.
In the report I have a filter named Month and two boxes as shown below.
Month : March
Month : April
The logic for IN/OUT calculation is Count(distinct Name) for each of the status.
Now here I want 0 to be displayed in case of Blank.I tried every possible way,whether it be IIF(ISNULL....) or ZN but could not get the required results.
It is not happening because the data is not at all present for that particular status and month in the database.
But still I want this to be displayed as 0 (requirement of the client).
Any help in this regard will be highly appreciated.
Looking forward to hear from the best of the Tableau minds here
Thanks in advance!!!
I believe you can try going to Analysis Menu -> Select Table Layouts -> Place a check mark next to Show Empty Row or Show Empty Column.
I included a sample workbook.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...