Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
Hi
To hide the '-' values, you can click on "Supress When Value is Null" in properties, dimensions tab.
Hope it helps.
You could use Only-statement to set which values are included
Hi
To hide the '-' values, you can click on "Supress When Value is Null" in properties, dimensions tab.
Hope it helps.
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
Yep!! forgot the presentation tab!
Thanks 🙂