Forum Discussion

Frequent Visitor

8 years ago

KPI Visuals and (Blank) - Issue with making (Blank) a 0

The measure that is being displayed in the KPI is a monthly average of several of the DISTINCTCOUNT measures displayed on the right. If it can't find any occurrences it returns (Blank), resu...

Need Help

MarkMellink

Frequent Visitor

8 years ago

Yes here is some sample data with the (Blank) occurrence (the app example in my OP):

https://ufile.io/5lz3u

Here is sample data without the (Blank) occurrences (the user example in my OP), but that can be used to test 0 problem once you add +0 to the formula:

https://ufile.io/41nve

They're .csv files. If you would prefer something else let me know!