Hello,
Similar to this post: https://community.tableau.com/s/question/0D54T00000C6R40SAF/how-to-count-nulls?t=1709865722620
I am looking to count the items in a column including the nulls. I tried using the solution found in this post, but it does not work for me as it ONLY counts the nulls, it does not count the other items.
They used: SUM(IF ISNULL([Status])THEN 1 ELSE 0 END)
Is there a way to count each category found in Status including the nulls in one column versus having to do two calculations and having two columns?
IE:
Status
Null - 3
Complete - 5
Pending - 6
Return - 2
Thank you!
PS: I do not have a sample as the computer that has the license is on an intranet server and not connected to the actual internet.
Hi @Michelle E
You could try COUNT(IFNULL([Status],''))
https://tarsolutions.co.uk/blog/null-functions-in-tableau/#ifnull
Let me know if this works in you scenario.
Ta, Steve.
