I am trying to show how many unfilled positions we have, and having trouble counting missing values.
The dataset contains the following:
- store name
- other stuff
Not sure it matters, but because of the other stuff I have in the dataset, each person apprears more than once in the data.
I want to create a table that shows how many missing positions exist by region. Assumption is that each store should have at least one person in each of the roles. The header should look like this:
Region | # stores | job1 | job2
A 20 2 5
B 50 1 7
So we see that in region A there are 20 stores, 2 don't have job1 filled and 5 don't have job2 filled.
Any help would be appreciated. I tried the ZN() function, ISNULL() function, but can't seem to get what I need.
Sorry for the delay in receiving a response! If there is no data in the data set. Tableau does not know to count data that does not exist. Instead, you may want to add the stores with missing positions to the data.
Hope this helps!