Chart suppress NULL but show zero

[Anonymous]

Hello there,

How to have a chart show zero values and suppress null?

Here is what I have now if I uncheck Presentation -> suppress zero-values

Some dimensions have null value but other have zero.

How to truncate those dimensions with NULL and keep those with a value which could be zero or other value.

Help is very appreciated.

Thanks,

Josh

[rahulpawarb]

Hello Josh,

As a workaround, you can use SET NullInterpret = '-1'; statement in script and filter those records with -1 value.

Regards!

Rahul