Hi all, I’m working on an Ignition report where I have a main query that returns a list of stations. For each station, I have a nested query that retrieves related event data specific to that station. [imagen] In my report, I display a table with one row per station, and inside each row, I embed…

Hmm. Unfortunately, the data you have access to in configureChart is already flattened so you don't have access to the nested data structures. The first workaround that comes to my mind is a scripted datasource that iterates through the nested query results (where you can access them) and generates…

I ended up solving this by using the row number from the table as the X-axis label. In the configureChart function, I retrieved the row index to look up the stationId from the top-level query results. Then I used that stationId to filter the events dataset. plot = chart.getPlot() domain_axis = plot…

Inductive Automation Forum

Reporting. Access report table row index or nested query data in configureChart() script

Ignition