Bell Chart curve

[#1]

Hello all,

I plotted a bell curve with Dimension as Class(Performance,0.1) and Expression as Count(Performance) and am getting bell curve like below image.

But median and Standard Deviation needs to be taken into account, Please help me in doing this.

Thanks in advance.

[adamdavi3s]

have you explored the normdist function?

[adamdavi3s]

A good example here:

https://community.qlik.com/thread/139251

[Clever_Anjos]

Re: Bell curve

[#5]

Hello Clever,

Thank you for valuable reply.

Can you please copy and paste the code? coz we are using Personnel edition ,not able to open example:(

Thanks In Advance.

[#6]

Hello Adam,

Thank you for your valuable reply.

Now i changed dimension as

normdist(  CLASS(Performance, 0.1) ,avg({1} total CLASS(Performance, 0.1)),stdev({1} total CLASS(Performance, 0.1)),0 )

Now the chart is looks like below

But the requirement is the bell curve should shows which group of sellers are the mean and where other sellers should be at in terms of performance to goal.

Please suggest.

Thanks in advance.