Reports: Average time to resolve per category

[MS12]

Hi,

I'm trying to create a report that shows categories on the case table on the x-axis and the average days it takes to solve the cases in each type on y-axis as a bar chart. This is a custom table inheriting from the customer service case table.

Created a report based on task SLA table but that shows the resolution time as a range - how many cases closed in a day, 1-2 days, <1 week etc..

It doesn't give the average days to resolve per category. I tried using the metric table as well but didn't work. Is there something I can do to get this information? PA reports is an option but I don't want to do that if I don't have to.

The pic below is what I'm looking for. I'm not getting correct numbers here. 

Thanks!

[Muralidharan BS · Accepted solution]

Hi MS

It would be best if you used the aggregation option in the report, go for a Bar report and try this option.

Thanks

[MS12]

This was helpful. Thank you!