Easy Chart with DB pens
using either built in Save button or exportDatasets() yields same results.
Not sure if its just something I am doing but I have found that when saving Datasets to Excel from an Easy Chart it will normally add all pens in a sub plot in a single dataset. perfect…
However if I add a Where Clause to a pen it creates a separate dataset for that pen. Giving you multiple sheets in the excel workbook. Not so perfect…
If anyone may have a work around… much appreciated.
Unfortunately, pens can only be consolidated into a single query if the datasource, table, timestamp column, and where clause are identical. Each separate query yields a separate result dataset. The chart doesn’t modify any of the datasets it gets, it just draws each pen out of whatever dataset it has.
You could dig under the hood and extract all of the data and script your own join across all datasets to yield a new one. You’ll have to deal with the fact that timestamps may not match up perfectly across all queries, requiring either intimate knowledge of the process to reasonably compute appropriate t_stamps, or insert all timestamps, leaving nulls in the dataset. Not a trivial task.