I am looking to build a report that shows my teams daily average cases closed, over intervals of a month or rolling 30 days (not too fussy). This will give me a better, bigger picture view on if a member of my team, as a whole is hitting their volume of case solved objectives, taking into account days where they get a bunch of tricky cases.
has anyone had any luck with this, as I cannot seem to get it to work.
I'm guessing its somehow measuring Avgs of Record count, with closed date grouped into months?
Jenna Weiner (AgWest Farm Credit) 
Forum Ambassador
I rolled this around in my brain a little and this is what I came up with, not sure if it's what you're actually trying to do, but just in case... ๐
I created a new report using the Cases report type. Grouped rows by case owner and columns by closed date. Then filtered for closed only, and for the last 30 days.
Then I added a summary formula to take the rowcount/30 at the grand total level for the case owner grouping.
It looks like this:
Top number in the total column is the average cases closed per day (which may be inaccurate considering in my example there aren't cases closed each day), and the bottom number is the record count for the total number of cases each person has closed in the month.
