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?
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
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.
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!
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.)
