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