Duration Score

The Duration Score is a good way to to track metrics such as Mean Time to Resolution.

Required Fields

• table - the table to query.

• conditions - the conditions to apply to the chart

• duration_field - the duration field to report on

• aggregate_type - the type of aggregation to use

Optional Fields

N/A

Return Data

An array with a single object that contains 4 key/value pairs.

• days - the number of days

• hours - the number of hours

• minutes - the number of minutes

• seconds - the number of seconds

Example Payload

A Javascript Object:

[{
    'days': "58",
    'hours': "22",
    'minutes': "47",
    'seconds': "57"
}]

A screenshot of the data in ServiceNow: