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?

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */