Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

create a report for Requested Items grouped by time duration

Piyush Dwivedi
Tera Contributor

Is it possible to create a report for Requested Items grouped by Time duration they are open?

1 REPLY 1

glideFather
Tera Patron

Hi @Piyush Dwivedi, yes that would most likely by possible.

Do you need any additional details or just their duration? Some might be paused or pending any blockers...

If you take [task_sla] table into consideration, then you will filter the records for a table [sc_req_item], and then you should be able to get this detail.

 

Do you aim to have this as a one-timer or to be checked regularly?


✂-----Cutting-out-the---✦AI-noise✦---All-replies-written-and-vouched-for-by-GlideFather---