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.

[Apurva Malewad1]

Hi Gururajan Ramasethu,

I think as you are using 'per week' that's why it's showing in multiple columns/bars splits of time series report.If you trend by 'opened' and try using 'Year' in 'per' column once. Otherwise use any other type of report like single score as you want count only. Displaying data as per configuration fields may vary result visualization depending on different types.Better if you use only 1 type to achieve this scenario.

And to correct you 'weekly' trend is showing from Monday to Sunday in each case. So report will be shown on let's say Today(16-10-2020) and next will be on Next Friday(23-10-2020).

Please mark my answer as Correct/Helpful if it helps you to find the solution.

Regards,

Apurva

[Gururajan Rama1]

Hi Apurva,

The problem is that my count for last week in a Single Score report is different from the count in the Opened Incidents Weekly Trend report. How do I explain the difference? What's the purpose of having Trend by Week Option?

Why would it show 10-04-2020 as the Week when I have configured Monday as the Start of the Week i.e 10-05-2020 in that case?

Thanks,

Regards

Guru

[Apurva Malewad1]

Hi Gururajan Ramasethu,

Count should be same but results vary according to the display option. Trend by week is used to show data by week. As you you are giving same filter in both cases, data should be same but visualization as per the type of report will be different for single score and Time series report.

If you have any further questions, let me know.

Please mark my answer as Correct/Helpful if it helps you to find the solution.

Regards,

Apurva

[Gururajan Rama1]

Unfortunately, it is just so confusing for the users...what I am worried about is the count and not the visualization...how do we make the trend by week report show the same count using the week as "Monday - Sunday" ? I am not convinced that ServiceNow would have overlooked this part.