Hello,
I am very new to Performance Analytics and need some help. We tried creating a PA Indicator to get the sum of a duration field of a few thousand records. For some reason, the dashboard shows 0 for the sum. Is it possible to add duration fields? In the screenshot below, the highlighted item is what we want to add up.
Thanks,
Maria
Hi Maria,
a duration field is actually a datetime field so you can not simply sum the values from that column but you first need to translate those values to numeric values. In Performance Analytics you can create a script (Data Collector > Scripts) that is called during score collection. For example, a script on the incident table for the field Duration (with a column name of calendar_duration, use that in the actual script) could look like:
Durations are stored as offset in milliseconds from Jan 1, 1970; hence the division by (60 * 60 * 1000) to retrieve a number in hours.
Next the script is used when defining the indicator. For example an indicator that retrieves the Average duration of resolved incidents, looks like:
The result looks like:
Hope this helps.
Cheers, Pieter
