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.

[joemmendoza]

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.

[Adam Stout]

You can't really create an age field since it changes every second.  What are you trying to get?  Performance Analytics handles this by calculating the age once a day during the collection process.

If I need to report on it, I generally look to use SLAs since that is optimized for this task as well.

What are you trying to get from an age field?

[joemmendoza]

@Adam Stout , we are trying to calculate the age of the ticket from the opened date the requirements is to have a live counter counting the age of the ticket from its opened date

[JagjeetSingh]

Hey,

If you just want to show this to user on form load in platform then you can have this field with field  type as glide_duration and use an on load client script to populate the value.

But if you want this for reporting purpose then NO. As Adam said it changes every second.

Now, If you have PA and you want to use this for reporting purpose then you can use Age breakdown in PA which is available OOB to use. It will bucketize the requested items to show the age.

Was this helpful? Let me know by marking it so.

[JagjeetSingh]

@joemmendoza - Hi, Just checking on this one. Is your issue resolved? Can you please mark my answer correct or useful if it helped you to reach your solution.

OR if you found the solution yourself, I'd encourage you to share the solution here so that others can take help.