The Live Date Series Data report may be used to chart Live data together with non-Live data in the same Time Series Chart widget. However, the Time Series Chart widget cannot handle a lot of data, and it cannot perform calculations/post-processing on the data.
An alternative is to use the Live Historical Chart widget, with a table-valued SQL function as the data source. This allows non-Live data to be charted together with Live data, as well as calculations/post-processing to be performed on Live data before it is charted, without adding the data to DT_LOGGER_DATUM.
1.Create a new DT_LOGGER_SERIES row ('series'), e.g, using EQuIS Professional.
2.Set series_function for this new series to: sql_fn.
The SQL function (in Step 3) must accept the following two parameters:
1.INT – The LOGGER_SERIES_ID of the series that is added to the Historical Chart widget (i.e., the series that is created in Step 1).
2.DATETIME – The Start Date that is selected in the Historical Chart widget, when adding the series.
Note: The Historical Chart widget's default Start Date for "SQL function" series is set to three months ago. The Start Date may need to be set manually to display the desired date range/data.
Copyright © 2021 EarthSoft, Inc • Modified: 01 Apr 2020