"Last week" value in indicator source

[Flavio4]

Hi,

Based on https://docs.servicenow.com/bundle/quebec-platform-user-interface/page/use/common-ui-elements/concept/c_ValuesForDateTimeFields.html and in particular "A filter for Last week returns incidents from midnight on Sunday the week previous ending the following Sunday at midnight. It does not include up to the present day. " I set up an indicator source (valid for frequency weekly) with a condition
"Updated on Last week".

When the score collector job runs, though, scores are collected according to the actual day, e.g.: if I run the job today Tuesday 18.1.2022 (Relative, relative start 0 days ago, relative end 0 days ago) it creates scores with Updated values from 11.1.2022 (Tuesday) to 17.1.2022 (Monday) included.

I'd expect and I would like scores only with Updated "from midnight on Sunday the week previous ending the following Sunday at midnight".

What am I doing wrong and how to correct it?

Thanks in advance
Flavio

[Adam Stout · Accepted solution]

That is not a normal pattern I would use.  I would set the indicator source to "This week" and sent the job to run from 1 week ago to 1 week ago.  That will make sure the week shown will that week otherwise the score from this week would actually be from last week which gets rather confusing.

[Flavio4]

Thank you very much Adam. Indeed I had tried several different patterns but not yours, which is indeed much better.

I think I understood why I got lost.

Let's suppose that today 20.1.2022 I have a ticket INC999 which:

- was updated on 12.1.2022 (last week)
AND
- was updated also on 19.1.2022 (this week)

When I check, for example, in Analytics Hub, Show records, for INC999 of course I see "Updated 19.1.2022", but indeed I just realized that it is correctly scored on Week 2 (last week). Indeed it was collected because on the collector run "from 1 week ago to 1 week ago" on the date filter "Updated on This week", based on the previous update on 12.1.2022, not because of the update of yesterday.

In other words, the collector applies the condition of the indicator on ANY record update date that applies to job collector run parameters (if any), not on the last update date, right?

I guess I got confused because it is the first time I use “Updated” for indicators.