Hello everyone!

One of crucial metrics that my company needs to report on involves an average number of tickets that were worked by a specific group in a given month. So for example, what was the monthly average number of tickets worked per agent that belonged to Customer Service group (10 members).

At the moment, we're getting this number manually by keying Zendesk tickets w/updates per each agent in a given group into a spreadsheet, which later divides this to return the average number of tickets worked in each month. We want to refrain from using spreadsheets though and keep the data in one place (Explore dashboards).

Is there any way to achieve this in Explore? We tried building custom metrics but didn't come up with anything that looks reliable.