Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart where I want to show last 12 Months on the X axis everytime,even if no data is available. I have used the 'Show all values' in the Dimension tab. However this also shows a NULL value sometimes(when no data is available). I have checked the option 'Suppress when value is NULL' but it doesnt make any difference. Is there any way to hide this null value?
Try something like below:
where Your_field_name <> ''; (Use in script)
or
=If( Your_field<>0,Your_field,null()) ( Use in Expression)
Thanks
AS
use {1} in your expression. It will show all data.
like this:
Sum({1}Amount)
Regards
Aviral Nag
Try something like below:
where Your_field_name <> ''; (Use in script)
or
=If( Your_field<>0,Your_field,null()) ( Use in Expression)
Thanks
AS
Try supress null on Presentation tab
Thanks. I used it in the expression, and its working now