I've been having a lot of trouble this past week trying to figure out how to create an average of a dataset that I generated.
Firstly - I've generated the following data which returns the total number of public replies a given agent sent on a given day.
For reference, the Daily Replies metric is calculated simply as
The problem I'm having is trying to take these individual totals per day, and create an average for the year. Our goal is to generate a given analyst's year-to-date daily reply average, ideally only including days that they actually sent a reply, but I cannot work out how to pull an average out of this.
I've tried using a calculated metric to divide total number of public comments over a count of days worked, but the problem with this is I also can't figure out how to make the Updates - Date filter into a metric, custom or otherwise.
Any pointers or tips toward accomplishing this would be greatly appreciated.