How do I get a count of null values in a dimension?

[nikita42]

In the attached QVW, I have people in different cities mapped to a function. I need to compare the total number of people in each city to the number of people who don't have a function assigned to them.

For some reason, my expression for the null values is giving me the same result as the total number of people in that city.

Need help ASAP.

Thanks

Nikita

[sunny_talwar]

Try this:

NullCount(Function)

[nikita42]

That does seem to work, but I don't understand the function. I need the count of IDs without a function, but in your expression, there's no mention of ID counts at all.

If I had more dimensions in my file, would this work?

Could you please explain the logic behind this expression?

[sunny_talwar]

So since the tables are associtated with one another when I do a nullcount() I see the nullcount of function for each of the city. Look at the screenshot below

London has two places where Function is Null. and Paris has one. Now if there is a possibility that there are duplicate IDs in the table, then it might become a problem. There could be other problems as well, but the best way is to test it out and see if it works.

[Anonymous]

=NULLCOUNT(FUNCTION)

[sathishkumar_go]

You can use the below expression also

count(if(len(Function) < 1,ID))

-Sathish

[mickartik]

Use NULLCOUNT()