Notifications

1185 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
New York Patch 3 Hot Fix 1
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - ITOM - CMDB CI Class Models - 201907
SR - ITOM - Discovery and Service Mapping - v1.0.35
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - CrowdStrike Intel Integration - Madrid 2019 Q1
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Splunk Sighting Search Integration - Madrid 2019 Q1
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - SIR - Threat intelligence - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Fixed In

New York Patch 9
Orlando Patch 4
Paris

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-05-21 12:42:40
Published:2017-06-09