2 Replies Latest reply: Sep 29, 2015 8:52 AM by Ruben Marin RSS

    Total average as measur

    Meelis Eesoja

      Hi,

       

      Problem is how to create a measure of total average. I hava fields Date and Visits. I want to display average per day calculated on total numbers on the graph. Problem is that if I make a selection of Dates then average is calculated on the basis of the selection. Expression that I try to use is following:

       

      SUM(Total  [Car Chapter Total Visits])/Count(Distinct Week(Date))

       

      How can I make this work?

       

      BR

       

      Meelis