Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a simple pie chart with no dimensions, only expressions. Each of them is calculated, f.e. like this (just diff status)
COUNT({<[Status]={'Finished'}>} DISTINCT [Contract])
On few statuses I get zero values in the legend (count = 0)
How can I display only not null values in the legend?
Presentation tab -> suppress missing/zero-values is not working.
Thanks.
Regards,
M.
Tick on Suppress when Value is Null in Dimensions Tab
Not available, since there are no dimenions to select
Use Expression condition to Show, see example
Regards
Thank you Martin.
I was putting >0 into ()...
Have a nice day!