Hi All, I want to calculate the age of the incidents , requested items and catalog task on the table. Could some one please help me on starting from creating the Age field and till it calculates the age.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-21-2021 01:51 PM
Hi All, I want to calculate the age of the incidents , requested items and catalog task on the table. Could some one please help me on starting from creating the Age field and till it calculates the age.
- Labels:
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-26-2021 12:50 AM
Hey, you can also try by creating KPIs as per your requirement like - 0-1 days , 2-5 days.. etc and they will take snap shot everyday at 00:00 hrs.
This helps me in my project to show ageing trend on each day without using PA.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-28-2021 03:12 PM
Without Performance Analytics I see at least the following options:
Metrics that start counting from the moment the record is created.
Service Level Agreements (SLAs) and a database view to use the duration field.
Duration field that increases by 1 day with a scheduled job that runs once a day.
Calculated field that measures the difference between record creation and current date/time.
Each has its advantages and disadvantages. For all of the above, it would be a good idea to define a stopping point to avoid using system resources on inactive records, like stop updating the age when the record is resolved, closed, or cancelled.
