Report to calculate the time to the ticket is submitted to the time it is closed(RITM).

Mahesh Pydisett · ‎09-11-2024

Hi Everyone,

Can you please help me on this requirement to get the report of the time to the ticket is submitted (created)to the time it is closed for SCTASK.

I would like to get the closed time report for below time frames.

< 5 days

6-10 days

11-20 days

> 20 days

Thanks in Advance!!

Dr Atul G- LNG · ‎09-11-2024

Hi @Mahesh Pydisett

This report i created on Sc_task table

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

AndersBGS · ‎09-11-2024

Hi @Mahesh Pydisett ,

First of all, you need a field to capture the submitted --> closed time frame. Next, you need report ranges created to get the timeframes listed in your report.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/