HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Reports in V2.7.0


#1

I’m trying to run a single report in 2.7.0 showing the total number of calls over a fixed period (eg 30 days) and what percentage of those calls are closed within different time parameters i.e. how many were closed within 30mins then how many within 4hrs and then how many within 24hrs and then how many with 48 hrs etc…
Is there one report that can do this? any help will be much appreciated.
thanks.


#2

Hi Rob,

There’s not currently a report that breaks it out like that. The resolution speed report will give you averages and medians but not a count of X in Y hours, etc. That could be done via direct SQL especially if you’re not worried about business hours and just total time from open to closed.

In that case you just minus the closing time from the starting time in HS_Request and do your counts as needed.


#3

Hi Ian,

Thanks for your help, it’s much appreciated.