Would the following give the correct answer?
[percent_complete_of_mailed]/sum([Number of Records])
1 of 1 people found this helpful
Hi Tracy -
Good idea, and the calculation is valid... but how to use? It's like I want a grand total row, but instead of the grand total, I want this average put there instead. Your calculation would work b/c it would know the number of records in the column. However, if I put your calculation, say, on the level of detail, it's messed up because it doesn't know which number of records to use.
This sounds like it's calling for a dashboard with two worksheets - one with the detail, and the second with the overall average per week. Does that make sense?
Thank you for all your responses. Ultimately, what did work was to use window_avg([percent_completeOfTotalMailed],first(),last()). I used this on a level of detail shelf so one could at least hover and see the average for that week.