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

# gauss curve in histogram

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

• ###### Re: gauss curve in histogram

I think you failed attaching the document

• ###### Re: gauss curve in histogram

Hallo Falko,

try to change your formula appropriate to:

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

Regards,

Eddie

• ###### Re: gauss curve in histogram

Hi Eddie,