Calculate average of a duration field (variable of Request item)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2022 03:13 AM
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,
- Labels:
-
Reporting

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 12:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2025 07:22 AM
Knowledge record not found

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-18-2022 12:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-28-2025 07:23 AM
This KB, referst to: Idea Management for Customer Enhancement Requests.
Not quite replying my answer