3 Replies Latest reply: Apr 10, 2014 5:34 AM by Falko Thom RSS

    gauss curve in histogram

    Falko Thom

      Hello community,

      I am quite new experiencing QV.

      I have to build a diagram containing a histogram and a bell curve (gauss curve / normal distribution).

      For drawing the histogram I am using formula

      =count( [DLZ-Tage])

      For drawing the bell curve I am using formula

      =normdist((ceil(min([DLZ-Tage]))+Floor(Min([DLZ-Tage])))/2,avg({1} total [DLZ-Tage]),stdev({1} total [DLZ-Tage]),0)


      [DLZ-Tage] ist the amount of days it takes a single piece of work to be comleted.


      My only dimension is

      =class([DLZ-Tage], 1)


      In my diagram both graphs are shown (see snapshot), but I want the maximum of the bell curve to be drawn at the median (represented by the orange dotted line).



      Anybody an idea?


      Unfortunately I didn't receive an answer anfter I added the graph. Has anybody an idea that could help me?


      Nachricht geändert durch Falko Thom