Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Data Visualization Trend by Week - bring back legacy week ending 'date' vs. week# on x-axis

joshcrew
Tera Contributor

3 weeks ago

Classic Reports populates the x-axis using the week dates
2026-07-06 10_04_29-Document1 - Word.png

 

Under Platform Analytics - Data Visualization, the same report, the x-axis uses Week# instead. While there is a tooltip to get the week start/end date, this is not available on a Scheduled Export of the data visualization/report. Stakeholders that do not want to consume via ServiceNow are expecting a week end date, as that is more meaningful then the Week # (i.e., 07/04/2026 vs. Week 26).

2026-07-06 10_05_45-Inbox - josh.crew@asmresearch.com - Outlook - Copy.png

 

Preview file
53 KB
Preview file
84 KB
0 Helpfuls
  • 520 Views
1 REPLY 1

Vikram Reddy
Tera Guru

2 weeks ago

Hi @joshcrew,

 

Data Visualization has no native setting to swap the Week# label for a week-ending date on the x-axis, and that gap follows the chart into any scheduled export, since the export is just a snapshot of what's rendered. Classic Reports never had this problem because its weekly trend groups on the actual date field, which is exactly why your first screenshot shows real dates like 2025-01-06. Data Visualization instead groups on the pa_bucket record and labels by ISO week number, and there's no field mapping in the UI to change that label format.

  1. For any chart that has to leave ServiceNow as a file for non-ServiceNow stakeholders, keep it on Classic Reports (Trend by Week, Standard calendar), same as your first screenshot. It already renders week-ending dates and schedules fine.
  2. If you need to stay in Data Visualization for dashboard reasons, a ServiceNow engineer posted a workaround on a recent community thread: clone the widget, build a label-to-date map from the pa_bucket table server-side, and override the Highcharts x-axis formatter client-side. It fixes the on-screen chart; I have not seen it confirmed to carry through to a scheduled export.
  3. As a fallback, a scheduled export off the underlying table grouped by week keeps real date values in the row data, since it bypasses the chart renderer entirely.

Are you locked into Data Visualization for other reasons (drill-down, dashboard embedding), or would swapping just this one chart back to Classic Reports actually solve it for your stakeholders?

 

Thank you,
Vikram Karety
Octigo Solutions INC

0 Helpfuls