Indicator with condition last 3 month display current month records too

[JohnDF]

Hi everyone,
my question is whether this behavior in ServiceNow is standard or if I have set something incorrectly?

Selected last 3 Month, but it display the current month record too.

Here is my configuration:

Yesterday, I created a historical snapshot to initially capture the last 12 months up to today.

Then I changed the job so that new records are captured daily.

Here is my monthly indicator source.

Here is an example indicator that the job should use to capture the current SLA incidents of the last 3 months on a daily basis.

I have also activated "Override Collection Periods" because I created an initial snapshot for the last 12 months but now create daily new monthly snapshots based on the condition so that the old ones are overwritten and the current data is always available. I hope this assumption is correct.

With this setting, I hope I have done everything correctly.

Do you see any errors?

Thanks for the help.

[Mark Manders]

It's annoying, but it's how ServiceNow calculates it: https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/use/common-ui-elements/...

This doc shows that it gets every thing from the start of the selected time frame (in your case, the 1st of 3 months ago) up until now (including the current month. It's a ServiceNow thing. Maybe you need to include an 'and before this month' to exclude the current month.

[JohnDF]

@Mark Manders thanks for the reply,

I will add the condition 'and created not on this month' I will test and come back.

But the rest of the setting looks good for you right?

[Mark Manders]

The settings seem to be OK, but can of course only be validated by checking on the data and I don't have access to that.