Hi all,
I’m running into a challenge with the XY Chart in Ignition’s 'Reporting Module', specifically related to how it handles time-based data on the X-axis.
I have a chart currently populated by a query that counts parts per hour, and it works fine when displayed across an 8-hour range. However, when I modify the query to count parts per minute instead of hourly, the resulting graph becomes unreadable or just returns "garbage" as if the chart can’t handle the volume of data being fed into it.
Here’s some context:
- The data range I’m charting is an 8-hour shift. (Bound to a pop up calendar and shift dropdown menu in a report viewer window.)
- Hourly counts produce a clean and readable trend.
- Minute-by-minute data required by management (which would mean 480 data points for an 8-hour shift) seems to overwhelm the Reporting Module’s charting capabilities.
- I’ve already attempted modifying the chart configuration with a script to allow for more plot points, but the issue persists. I have since deleted these scripts but I can recreate them if you need more insight.
Has anyone else encountered similar issues with XY charts in the Reporting Module when increasing data granularity? Are there best practices or workarounds (like downsampling, aggregation, or custom scripting) that have worked for you?
Thanks in advance for any insight.
Regards,
Stephen