topic Need to develop Normal Distribution in App Development

Need to develop Normal Distribution

ferha_jafri — Mon, 29 Apr 2024 09:52:23 GMT

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

Re: Need to develop Normal Distribution

igoralcantara — Mon, 29 Apr 2024 12:15:08 GMT

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!

Re: Need to develop Normal Distribution

ferha_jafri — Thu, 09 May 2024 06:13:09 GMT

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.