How to add a filter condition to get Tasks resolved within of 24 hours of its creation

[The Matrix]

Hi Team,

I have to preapre a report on sc_task table where I need to pull the Tasks resolved within creation of 24 hours.

How to add a filter condition to get Tasks resolved within of 24 hours of its creation ?

[pr8172510]

Hi @The Matrix,

For a report on sc_task, there is no OOTB filter that directly compares Resolved At and Created timestamps.

 create a condition based on the duration between Resolved At - Created

and filter for records where the duration is <= 24 hours

If you're using a report, you can:

• Create a Database View or Report Source with the duration calculation, or
• Use Performance Analytics if available.
  
  

Also ensure you filter only resolved/closed tasks  
State is Closed Complete AND Resolved At is not empty

[Tanushree Maiti]

Hi @The Matrix 

Navigate to Reporting: Go to Reports > Create New

Set the Data Source:

• Report name: Tasks Resolved in 24 Hours
• Source type: Table
• Table: sc_task

Configure the Filters:

• Navigate to the Condition Builder and add the following condition rows:
• [State] [is] [Closed Complete] (or your chosen resolution state)
• [Closed] [relative on or before] [1] [Days] [after] [Created]
• Alternatively, you can use [Business duration] [less than] [24] [Hours] if you wish to calculate working hours rather than calendar time.

Refer: How to create a report which are created and resolved in 24 hours 

https://www.servicenow.com/community/itsm-forum/report-where-created-is-gt-24-hrs-and-lt-48-hrs/td-p...

[Dr Atul G- LNG]

Hi @The Matrix 

If you only need cases that were closed in the last 24 hours, then please apply a filter for records closed within the past 24 hours and use that dataset instead.

You can try like this

[Ankur Bawiskar]

@The Matrix 

OOTB the sc_task table has closed field which gets populated when task is closed

then you can use this in reporting

if you want to use Performance Analytics then check this where I shared a comment

Generate report on incidents resolved within 10 mins & show percentage compare to tota records 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏