12 Replies Latest reply: Mar 11, 2014 8:30 AM by Manideep Hv RSS

    Issue with Normal Distribution(Gaussian Distribution)

    Manideep Hv

      Dear Community,

       

      I had an issue with Normal Distribution Curve. My curve shows like below Image:

      Capture.JPG.jpg

      Here My Dimesnion is =if(BC_DEV<>' ', class(BC_DEV,0.01))

      Expressions:

      For Bars: =Count(DISTINCT  LENS_MASTER_SEQUENCE)

      For Bell Curve: =if(BC_DEV<>'',NORMDIST(Class(BC_DEV,'0.01'),avg({1}TOTAL BC_DEV),Stdev({1}TOTAL BC_DEV),0))*2000

      In the above expression I am Multiplying the expression with 2000 to get the curve in bell shape, otherwise it is like a flat straighline on X-Axis. And also I do not want to make the expression static by multiplying with 2000 or any other number.

       

      If I make any selections I am not getting the exact curve for those particular filters. Please find the image below:

      Capture2.JPG.jpg

      I want the Normal Curve to be calculated for any selections.

       

      Please help me in achieving this. Thanks a ton in advance.

       

      Regards

      Manideep