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

    Total average as measur



      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?