The CreatorCon Call for Content is officially open! Get started here.

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
Tera Contributor

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.

11 REPLIES 11

joemmendoza
Tera Contributor

Hi @Jagjeet Singh,

 

The OOB Dashboard in PA says its inactive can you advise how to modify this.

Hey! Do you mean that dashboard is inactive? Can you show the message.

Jagjeet Singh
ServiceNow Community Rising Star 2022/2023

find_real_file.png

I activated the dashboard but still no data available

 

find_real_file.png

Okay. To populate the data you need to create and execute data collector jobs.

Below are the indicators used on this dashboard.

Number of open requested items

Average age of updated since of open requested items

Average age of open requested item

Average re-assignment of open requested items

Summed age of open requested item

Summed re-assignment of open requested item

Summed age of updated since of open requested item

 

Create two jobs. One to collect the historical data and one for daily data. This should do the trick. Let me know if it worked.

I'd appreciate if you can mark my answers helpful or correct if it works for you.

 

Jagjeet Singh
ServiceNow Community Rising Star 2022/2023