How to Ignore some data in a chart

[#1]

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

[vivientexier · Accepted solution]

If(Expression <= 1

     , Expression

)

[#3]

"ignore" - You mean, You don't want them to appear in chart?

[#4]

yes, this is what I want..

[#5]

if I write on the condition this if, seems there are no effect in the chart, I still see the same data as before

[SunilChauhan]

see the sample attached file

hope this helps