Report for Resolved Incidents over the past weekend only?

[royalbay]

Hello,

I'm trying to build a report that shows incidents resolved the past weekend only, meaning after 5 PM Friday and before 8 AM Monday morning for example. 

I tried using 'trend > on or after Friday and on or before Sunday' but am getting blank results. Will continue to try different conditions, but any guidance would be greatly appreciated! 

[Sumanth16]

Hi @royalbay ,

Don't create new fields.  If you use trend and relative operators correctly, you should be able to express this.  You just need to make it a whole other OR condition to the "created yesterday" line.  Don't click the OR at the end of the condition line.  Click the NEW CRITERIIA button at the bottom of the report builder!!

Anyway... this will make a whole new query condition that selects anything from three days ago so long as its also on a Friday, Saturday, Sunday, or Monday.

If I could help you with your Query then, please hit the Thumb Icon and mark it as Correct !!

Thanks & Regards,

Sumanth Meda

[AndersBGS · Accepted solution]

Hi @royalbay ,

Utilize below condition which will fulfill your requirement:

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

best regards

Anders

[royalbay]

Thank you! Followed your settings with a bit of a tweak from 'created' to 'resolved' and got what I needed.