Line charts that trend by a date field per week do not properly display records for a group when week is split between two years.
The behavior can also be replicated using a GlideAggregate script.
Steps to Reproduce
Create or import some Changes and Incidents with a sys_created_on date and time between 2016-12-26 23:59:59 and 2017-01-09 00:00:00.
Create a Line Chart report with the following values:
Type: Line Chart
Group: Task type
Trend: Created per Week Enable Display grid
Filter: Created after 2016-12-26 23:59:59 and Created before 2017-01-09 00:00:00
For more information, see the documentation topic Line reports.
Execute the report.
Observe the differences between the chart and grid list.
Note that the behavior can also be replicated using a GlideAggregate script:
This problem has been reviewed by ServiceNow, after carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or future releases. We do not make this decision lightly, and we apologize for any inconvenience.
The only workaround consists in restricting the query from crossing over multiple years.
Related Problem: PRB594423