Jump to content

Average Resolve Time by Service/Category


dwalby
 Share

Recommended Posts

@dwalby you can achieve this using the advanced analytics.

1. Create a measure using the average aggregate - an example config below, you can ignore the clause or add in your requirements.

The important piece to include here is in the Saved data columns - include the attributes you want to group by - i.e service, category etc as well as h_fixtime as you will need this in the widget which will display the averages later. 

image.png

2. Sample your data

3. Create a widget based on the measure - data chart > Measure Group By

* Use the original date format, or convert it

* Specify a sample period to use

* Limit the results to x services or categories etc

* Choose the measure/s to use

* Choose from the saved data columns, what you want to group on

image.png

Hope that helps

Steve

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...