Add option to limit time period for 'Last Recorded Value' Data Context
For data such as daily volumes produced, we need exact values from PI and Interpolated data just doesn't fit in this case. So we need to configure such columns with 'Last Recorded Value' Data Context. With this setting we certainly get the last archived data from PI, however we do not know if the data is stale.
It would be great to have an option to limit time period for 'Last Recorded Value' data context.
Example: Replace stale data with NULL if data is older than a month/year.
Brent Bregenzer commented
I have seen this same need at an O&G customer where they want to report daily values. Another nice option would be the ability to report the timestamp of the last recorded value in a column. This way consumers could determine if the value fits their definition of stale or not.