Pareto chart not working for group by duration or date in Orlando and getting 'No data to display' message

Steps to Reproduce

Login to an Orlando instance

Navigate to Reports ---> Create New and create a report as below:

Report name: Pareto
Source type: Table
Data source: incident
Type: Pareto
Group by: duration or created

Run the report, notice the 'No data to display' message.

NOTE: If you run the same report in NewYork or previous versions, the report works fine.


There is no workaround to make Pareto chart work with "Group by" on date/duration fields but the Bar chart report type does wok with "Group by" date/duration fields. The resulting graph is not the same as Pareto as the line which shows the aggregate of the bars in Pareto is not displayed in the Bar report. Please consider using this as a workaround while the problem is fixed and you have upgraded to a fixed version.

Related Problem: PRB1399098

Seen In

SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Intended Fix Version


Fixed In

Orlando Patch 5

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-07-10 02:07:59