Need to develop Normal Distribution

[ferha_jafri]

Hello Experts, 

I want to do an analysis on Normal Distribution for Revenue. But not sure how to proceed with it as my requirement is to develop Bell Curve for Revenue as a measure. I am not sure how to proceed with it. Can anyone help me on this as anyone did any analysis on Bell curve for revenue.  

     I am using web version so please do not send the qvf files as will not be able to open them.

Thanks in advance

Ferha

[igoralcantara]

Sure. We do a lot of this here, so let me help you.

First, create a line chart. Add your numeric field you want to distribute (for example, LineSalesAmount) as a dimension (as, that's right).

Then, create a measure where you use the NormDist fuction. Here is an example:

NormDist(LineSalesAmount, Avg(Total LineSalesAmount), StDev(Total LineSalesAmount), 0)

In Appearence, go to the X-axis properties and make sure to check Continuous Scale on.

This is it!

[ferha_jafri]

Sorry for being late, I am be able to plot the graph. But actually I am looking for below chart but not sure, is it possible or not. So I want to capture the %age as the values in between Average and Standard deviations.