Report for Incidents from Entire "Last Month" including Wrong Data.

[Jordan Humphre1]

I have a report that is displaying last day of previous month to last month in a monthly report I am running...

My query looks like this:

All>Status in (Resolved, Closed - Resolved, Closed - Duplicate)>Duration is not empty>Resolved on Last month>Duration < 1 Day .or. Duration between 1 Day and 2 Days .or. Duration between 2 Days and 3 Days

This report is scheduled to run on the first of every month. When it ran last week on the 1st, it still included data from October 31st. I only want data from Nov 1-30th (the entire calendar month) included in this report when I choose "Resolved on Last Month" as a parameter. Any reason why this is behaving like this? Any ideas on how to fix it? I am using London P3.

[Darrion Burges1 · Accepted solution]

You are filtering the data correctly. You are filtering down to all tickets that were resolved last month, however, you seem to be TRENDING by created date. Be sure that if you only want to see tickets that were resolved last month, that you are only trending by the "Resolved" data found in the "configuration" section of the Reports Designer. 

Currently, you are looking at incidents that were resolved last month, but you are trending them by created date, so things that were created in October will still be there. 

[Jordan Humphre1]

That worked! Thanks!