Hi,
We have a report with two query data sources:
- One is a Named query, that queries three tables.
- The other query data source is a Script query that uses the rows from the named query result and generates the required datasets with history data for all the relevant tags. The result data sets are named: TagHistory_x where x is the device number.
In the Design tab there is a table with:
Data Key = Named query data source
With Grouping:
Device
Named query data source
In the Device Details section of the table there is a Timeserieschart that it should show the data from the data set gathered by the script data source, TagHistory_x
Do you know how to dynamically assign the data set to the Timeserieschart Datakey?
I have tried:
- In the result from the Named query data source there is a column with the Dataset to pick: TagHistory_x. We can read this field in the table properly using: @DataSet@ (name of the column).
- @DataSet@ in the Timeserieschart Datakey it doesn’t work
- DataSet in the Timeserieschart Datakey it doesn’t work
- If I add manually in the Time Series Chart Data Key: TagHistory_ 1, the chart works