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.




      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:




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


      Thanks for the help.


      Tom Müller