How can filter by Null/Blank/Empty fields

[Anonymous]

Hi,

I have a dashboard that display the count of IDs by products (dimension is product, expression is count(ID)), the problem is that the records that has product null, blank or empty it will display a '-' sign in the dashboard.

I also want to create a dashboard for those empty products, how can I exclude them for the first dashboard and create a new dashboard for where the product is null/empty/blank.

I have tried the following but doesn't work:

As dimension:

'=Product<>''  '''(those are single quotes)

As expression:

=Count({1< FYQTR = {"<>' ' "}>} ID) - Single Quotes

=Count({1< FYQTR = {"<>" " "}>} ID) - Double Quotes

The expressions are correct but the dashboard does not reflect that.

How can I fix this without altering the LOAD of data?

[sunny_talwar]

May be try this:

Dimension

If(Len(Trim(Product)) = 0, 'Empty/Null')

Not sure what you are checking in your dimension? Product again?

[Anonymous]

Didn't work, I got 2 bars in my dashboard, one with a - and the other one says the value that I set in the Dimension.

Yes, The dimension is Product and the expression is Count of ID, I have created the other post because I thought this one failed.

[sunny_talwar]

Look at my response and the other response here:

Remove the blank values from a chart