Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I uncheck the Include null values option, my Null values go away. But this formula in my calculated dimension does not turn those nulls to my default. 60% of the dimension is Null, but my default returns less than 1% as "No App Found". Please let me know if there is something that I am overlooking. I have tried the IsNull and Len separately and neither of them are calculating to "No App Fount":
Hi Vinestim,
Your Nulls will always disappear if you uncheck 'Include null values'. You can't bypass that by doing something like
If(IsNull([Field]), 'Show it', [Field])
Because it's genuine 'null' value which has already been excluded before the chart even starts calculating.
If you want to add them, you should do that on the back-end when you are loading the data itself.
I hope that helps!
Kind regards,
S.T.