When a trend report is run against the 'Date/Time' field, the data is sorted in alphabetical order and not in numerical order.

Steps to Reproduce

  1. Login as administrator in an instance based on Oracle db.
    2. Go to Reports > Create New .
    4. Switch to the Classic UI.
    5. Select the below options:

    Table: Incident
    Type: Trend
    Group By: Active
    Trend By: Opened
    Per: Hour
    Aggregation: Count
    No. Groups: System Default (12)

    6. Run the report. Observe the output data appears in alphabetical order, i.e.: 1,10,11,12,13,14,15,16,17,18,19,2,20,21,22,23,24,3,4,5,6,7,8,9.


This problem is under review and targeted to be fixed in a future release. You can Subscribe to this article to receive notifications when more information will become available.

Instances based on MySQL database do not have this issue.

Related Problem: PRB1303260

Seen In

Jakarta Patch 9

Intended Fix Version

Madrid Patch 8

Fixed In

London Patch 10
New York

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:2019-08-21 14:17:09