Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a count set up to count the amount of users within a 'Group' field. So I set up a straight table with dimension of 'Group' and then an expression of
'Count(Username)'.
I was interested to find out that some of the groups have no usernames in them, however, they are not showing up in my straight table.
Is there a different way I need to do the count?
I already went into the straight table settings and unmarked the 'Surpress Zero values'.
Any help would be great. I can not post a sample.
Thanks
Hi,
Try this,
=If(Count(UserName) = 0, NullCount(UserName), Count(UserName))
Hope it helps
Hi,
Do u ve any other expression with it?or ur using single expression only in this straight table?
Single expression only in this straight table
You can add one more expression which always returns some non-null value for any group, e.g.
count(Group)
then hide it on tab Chart Properties -> Presentation
Try by checking the Show All values option in the Dimension tab