This content has been marked as final. Show 2 replies
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?