Notifications

335 views

Description

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

 

  1. 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.

  2. Create a Line Chart report with the following values:

    Type: Line Chart
    Table: Task
    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.

  3. Execute the report.

    Observe the differences between the chart and grid list.

Note that the behavior can also be replicated using a GlideAggregate script:

var ga = new GlideAggregate("task");
ga.addEncodedQuery("sys_created_on>javascript:gs.dateGenerate('2016-12-26','23:59:59')^sys_created_on<javascript:gs.dateGenerate('2017-01-09','00:00:00')");
ga.addTrend("sys_created_on","week");
ga.addAggregate("COUNT","sys_class_name");
ga.query();
gs.info("Task type"+"\t"+"Count") while(ga.next()) 
gs.info(ga.sys_class_name+"\t"+ga.getAggregate("COUNT","sys_class_name"))

Workaround

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

Seen In

Calgary Patch 1 Hot Fix 1
Eureka Patch 11 Hot Fix 2
Eureka Patch 6
Fuji Patch 8
Helsinki Patch 5
Helsinki Patch 6 Hot Fix 1
Kingston

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-01-25 16:31:47
Published:2017-06-09