How to limit +2sd more than 100% in chart

[#1]

Hi,

Attached is an image of the +2sd line that I have done up.

In this chart, the +2sd is more than 100%.  May I know how to limit the chart if it goes more than 100%.

I wish to set the limit at 100%

my calculation = Mean + (2 * SD)

Because the 2*SD is higher than the mean, this is why it goes out of 100%.

Would need advise on this.

Thanks

Chun Wey

[rubenmarin]

Hi Chun, is there if the max possible value is 100, you can use:

RangeMin(Mean + (2 * SD), 1)

[#3]

Hi Ruben,

it give me all 100% including other dimensions. Or should i include set analysis as well ?

[rubenmarin]

Hi, it's supposing to keep only the min value of your expression or 100%, not sure of what value is returning "Mean + (2 * SD)" if it's higher than 1.

Also probably needs to filter to show only values where not isnull(Mean + (2 * SD)) or change for a simplier:

If(Mean + (2 * SD)>1, 1, Mean + (2 * SD))

Again, "1" is meaning 100%, if your espression return 100 for a 100% it should be If(Mean + (2 * SD)>100, 100, Mean + (2 * SD))

Hope this helps, if not, with a sample I can give more help.

[#5]

Hi Ruben,

Thanks for ur help!

Attached is the qvw.

Please go to Monthly Performance Tab -> Question Type ->Select FC.

You will see the issue,

Thanks again.

Chun Wey

[SunilChauhan]

goto chart properties -> axis-> static max->

here type max(expression written in +2sd)*1.2

this will set max for you chart suppose is value then it will set to 120 as max

hope this helps

[#7 · Accepted solution]

Hi Chunwey,

so are you just wanting any of the individual points which go above 100% to be forced to 100% instead? Something like this?

hope that helps

Joe

[#8]

Thank you, yes, this is what i want.

[SunilChauhan]

would you think 100%  will be static when 2s value become 101 then it will give wrong projection.

[#10]

Hi chauhans85,

Yes, if it is more than 100%, it is definitely wrong projection.

This is why I am limiting to 100%.

Thanks

Chun wey