4 Replies Latest reply: Jan 9, 2018 4:40 AM by Tom Müller RSS

    Average value of orders

    Tom Müller

      Hi all together,

       

      I try to achieve a diagram, that looks like this.

       

      AVG.JPG

       

      I already got the diagramm, but what is missing is the average value. My dimension is "Projektleiter" and my measure is "Auftragswert", which is the value of a "Projekt". I tried to achieve a structure like seen above with the following formula:

       

      ((sum(Auftragswert))/Count(Projekt))*Count(distinct Projektleiter)

       

      My graph looks like this:

       

      Graph.JPG

       

      Is there any easy way to get the average amount as seen above?

       

      Thanks for the help.

      Regards,

      Tom Müller