Excluding values in dimension in charts

[#1]

I would like to exclude few values from the dimension in the chart, I am using if() statement, which is fine, however values which doesn't satisfy if() condition, comes as '-' separately. which is not required.  Any workaround ?

[#2]

You could use Only-statement to set which values are included

[#3 · Accepted solution]

Hi

To hide the '-' values, you can click on "Supress When Value is Null" in properties, dimensions tab.

Hope it helps.

[datanibbler]

Hi Shyamal,

exactly. That's what I was about to say.

However, this checkbox "supress when ..." exists twice - once on the "dimension" tab and once on the "presentation" tab (in the dimension_area, in the bottom half).

You'll have to experiment a bit with those two.

HTH

Best regards,

DataNibbler

[#5]

Yep!! forgot the presentation tab!

Thanks 🙂