Chart suppress NULL but show zero

Anonymous — Thu, 27 Apr 2017 23:51:33 GMT

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

Re: Chart suppress NULL but show zero

rahulpawarb — Fri, 28 Apr 2017 06:25:03 GMT

Hello Josh,

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

Regards!

Rahul