I added this as an feature request over on the Ideas site (here, if you’re interested in this too), but I was curious how others worked around this.
Most reports I’ve done can be made to work in the built in reporting module (which is very nice), but every so often I have to create a report that goes beyond what the reporting module could easily handle (or at the very least what I could personally do with it)
In the other packages I’ve used (iFix, FactoryTalk, and Wonderware) they’ve included a plugin for Excel to query their Historian and get values. Ignition doesn’t offer this so querying data that spans more than one automatically generated historical table can be problematic, especially as the date range increases, or the time between auto generated tables decreases.
Has anyone else used excel to handle advanced reporting? If so how did you accomplish handling reading data beyond a single table? Yes full unions would do this, but how did you handle telling it, programmatically, what tables to union?