MTTR report

TaianaR
Tera Contributor

Hello,
How to do the query with this clausula "Created > 3 days"?

TaianaR_1-1751917896468.png


Tks,

1 ACCEPTED SOLUTION

@TaianaR this is my example of Records that were created 6 days ago and after that:

KamilT_0-1751921560658.png



"Created > 3 days" means not in the last 3 days, right?
Then it could be more or less like this:

KamilT_1-1751921590427.png


Apply that condition and get an idea if it is as you want or make some changes to it.


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


View solution in original post

5 REPLIES 5

GlideFather
Tera Patron

Hi @TaianaR 

go to a list view first and try to play with the query conditions until you are happy.

 

it would be something like:

[Created] [on or before] [Relative] 3 [Days ago]

in the list view for incidents you can review it faster and then if all good you can apply on the report.

 

let me know if this put some light into the topic

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


@TaianaR this is my example of Records that were created 6 days ago and after that:

KamilT_0-1751921560658.png



"Created > 3 days" means not in the last 3 days, right?
Then it could be more or less like this:

KamilT_1-1751921590427.png


Apply that condition and get an idea if it is as you want or make some changes to it.


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


Thank you so much!
it worked!!! 😍

Great to hear that, have a wonderful day!

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