# Trouble Displaying Data on Timeseries and XY Charts – Need Help with X-Axis Configuration REPORTING

**URL:** <https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505>\
**Category:** Ignition\
**Tags:** ignition81, reporting\
**Created:** [May 21, 2025, 2:30pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505 "2025-05-21T14:30:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maria\_Sierra](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@Maria\_Sierra](https://forum.inductiveautomation.com/u/Maria_Sierra)\
**Post date:** [May 21, 2025, 2:30pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/1 "2025-05-21T14:30:07Z")

</div>

Hi everyone,

I'm working on generating a report that includes a timeseries chart and an XY chart, but I’m running into some issues.

The data is being pulled from a named query, and I can see the sample data correctly in the table. However, both charts are only showing a single timestamp and a simple line—no meaningful data points are being plotted.

I suspect it might be related to how the X-axis is configured. Has anyone encountered this before? Any suggestions on what settings I should check or change to get the charts displaying properly?

Thanks in advance for any help!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/0/30c42c74435d8f33165918ae27b3b0a840b01c04.png)

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [May 21, 2025, 2:53pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/2 "2025-05-21T14:53:05Z")

</div>

Share the Chart Options + the Query and the community can likely explain the issue. If I had to guess it would be because of the Domain Key Chart Option not being assigned to the correct column from the query. For example t\_stamp =/= timestamp

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/480f6ae4e994c32ef117712f6061766a60e02626.png)  
Screenshot from: [Getting Started with Report Charts | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/ignition-modules/reporting/report-design/report-charts/getting-started-with-report-charts)

---

<div class="post-metadata">

**Author:** ![Maria\_Sierra](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@Maria\_Sierra](https://forum.inductiveautomation.com/u/Maria_Sierra)\
**Post date:** [May 21, 2025, 3:08pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/3 "2025-05-21T15:08:57Z")

</div>

This is the configuration I have:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/9/297ad051dec8818746f3a0b1bcd054e11b274524.png)

I check all the keys and they seems to match with the data source in the query.

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [May 21, 2025, 6:08pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/4 "2025-05-21T18:08:41Z")

</div>

That does look good. If you go to the Preview, there is an XML output of the data on the right, is the format of the timestamp appropriate? You're probably right that it likely stems from the x-axis/ units for the time axis.

---

<div class="post-metadata">

**Author:** ![Maria\_Sierra](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@Maria\_Sierra](https://forum.inductiveautomation.com/u/Maria_Sierra)\
**Post date:** [May 21, 2025, 8:47pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/5 "2025-05-21T20:47:12Z")

</div>

**Issue Solved!**

After a long day of troubleshooting, I finally got it working!

The problem was that even though the timestamp column _looked_ like it was in the correct format, it turns out the report component needed the values explicitly parsed using `system.date.parse` in order to recognize them properly as `t_stamp`.

I applied `system.date.parse()` to each row in the timestamp column (you can see the parsed version in `tempUpdated`), and that did the trick. Once that was in place, the charts finally started displaying data correctly.

Hope this helps anyone running into a similar issue!

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/4/14862543f93f584a2ed34e400b0cc3385681728b.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/f/cf755abea5a0b6368186c2236a2aaff0715100c7.jpeg)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 22, 2025, 12:58pm UTC](https://forum.inductiveautomation.com/t/trouble-displaying-data-on-timeseries-and-xy-charts-need-help-with-x-axis-configuration-reporting/106505/6 "2025-05-22T12:58:19Z")

</div>

Ewwww!

That means your named query delivered strings instead of proper date objects in the first place. Did your named query format the dates? (Don't do that.)
