Trend By Week and Last Week Report Condition

[Gururajan Rama1]

Hi

I created one simple Incident report (single score) having Condition as "Opened on Last Week". Let's say I got 265 Incidents as example.

I created another Incident report using Time Series - Trend chart with

Trend By = Opened, Per = Week & Aggregation = Count

Report Condition remained the same as previous i.e.  "Opened on Last Week". Now I got two Bars (provided data table below):

Opened	Incident Count
10-05-2020	38
10-06-2020	37
10-07-2020	53
10-08-2020	56
10-09-2020	38
10-10-2020	22
10-11-2020	21
total	265

I would expect only one bar to show with count as 265. Why did it split into two? If I change the report condition as "Opened on Last 30 days" then it changes the count as below:

Per Week Trend is taking Sunday to Saturday where as the Last Week Report Condition is considering from Monday to Sunday. How do I correct this so that both are looking at the same time period? Thanks.

[Gururajan Rama1 · Accepted solution]

The issue got resolved after we set one of the below property value to 2 (Monday), these needs to be added to System Properties if default value needs to be changed.

glide.ui.filter.first_day_of_week = 2

glide.ui.date_format.first_day_of_week = 2

The below documentation reference was very useful:

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/reference-pages/reference/r_AvailableSystemProperties.html

Thanks.