Hi,
How do i generate a filter in a dashboard that only shows null values?
I tried to select the dropdown option but it gives me an error message.
I’m not sure what the correct way is, but sometimes it ends up easier to add or alter the BAQ calculated field to include a fallback option for the null. ISNULL() does it, or if you prefer you can add an extra field with a CASE WHEN TotalMtlReq IS NULL THEN ‘none’ or something similar.
Personally, I’d lean towards adding ISNULL(xxxx,0.0) into your existing field, then filtering on zero, but you may have reason to avoid that.