Line Chart reports display numeric values on the x-axis sorted alphabetically rather than numerically when trending on a date field and showing results per hour - Known Error

Line Chart reports display numeric values on the x-axis sorted alphabetically rather than numerically when trending on a date field and showing results per hour Description On Oracle db only, Line Chart reports show a wrong display order on the x-axis, not sorted numerically, when trending on a date field and set to show results per hour. The integer values are treated and sorted as text strings. So for example a sequence along the x-axis is seen as follows: 0, 1, 10, 11, 12, 13, 14, 15, 16, 2, 20, 21.

Steps to Reproduce

Replication steps:

Create a report on a transactional table as follows: Type = Line Group = None Trend by = Created Per = Hour Aggregation = Average > Business Resolve time Percentages = Use Aggregation

Run the report. > Expected behavior: The numbers along the x-axis should be sorted as numbers (i.e.: 0, 1, ..., 9, 10, ... 19, 20, 21)

> Actual behavior: The numbers along the x-axis are sorted alphabetically (i.e.: 0, 1, 10, 11, 12, 13, 14, 15, 16, 2, 20, 21).

Workaround After carefully considering the severity and frequency of this problem, 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 these decisions lightly, and we apologize for any inconvenience. If you have any questions regarding this problem, contact ServiceNow Technical Support .