Calculate average of a duration field (variable of Request item)

NikolasP1
Tera Contributor

I have a report for a request item, that contains variables. One of the variables is of type duration. 

I would like to have an average on this variable in the report. It seems impossible to do so, although the field seems to be a perfect fit for the purpose. What we get instead, is a result in unix time (so the average is converted in epoch time and you get a value somewhere in the year 1970...) 

We would like to be able to calculate the average of a field that the user can put manually the time spent on a ticket.

Could you help me on how to achieve this? 

tx,

7 REPLIES 7

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB1027656 for more information.

Knowledge record not found

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0755878 (HI login required) for more information.

This KB, referst to: Idea Management for Customer Enhancement Requests.
Not quite replying my answer