Problems with filter in report

[Alessa]

Hello dear community, I need help:

I have this report showing closed incidents (last 12 months):

When I select the incidents cancelled in May (as shown in the picture) I get the following result:

As you can see in "Closed" all the incidents closed in the month of May appear, but I don't know why an incident closed in June appears and that is not right. I need that only the incidents closed in the month of May appear.

This is the filter I am using for this report, could someone tell me where I am going wrong?

Thanks in advance

[JP - Kyndryl · Accepted solution]

Hi Alessa,

Last 12 months include the date you are producing the report:

https://docs.servicenow.com/bundle/rome-platform-user-interface/page/use/common-ui-elements/concept/c_ValuesForDateTimeFields.html

Try Between instead, like this:

Regards,

JP

[Christian Prob2]

Hi @Alessa ,

if i remember correctly there are two ways to interpret "last 12 months" - and I personally think it's incorrectly (and if not that then at least inconsistently) implemented.

If you select "on yesterday" it gives you all for yesterday.

"Last 12 months" is (unfortunately) not - if we are in June now - June last year to May this year, it starts on June 1st a year ago, but then includes records from the current month (June as well).

Happy to see that @JP Plouffe has provided a workaround - I needed that years ago 🙂

Best,

Christian

Please mark helpful or correct, if deemed so. Thank you!

[Eszter]

Hi Alessa,

from the breadcrumbs on your second screenshot I assume that the Trend by is set for the Created date, if you change it to the Closed date then it should only show incidents that were closed in that month.

Regards,

Eszter