Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to everyone.
I need your help to know how to ignore some value in a calculated dimension in a linear chart.
example:
my calculated field in the expressions have value like
A
95%
85%
55%
130%
75%
120%
I want to ignore all the value more than 100% in my linear chart.
how can I do that?
thank a lot
If(Expression <= 1
, Expression
)
"ignore" - You mean, You don't want them to appear in chart?
yes, this is what I want..
if I write on the condition this if, seems there are no effect in the chart, I still see the same data as before
see the sample attached file
hope this helps