Avoid interpolation of "on-change" historical tags in chart (or table) - ie show a step change

So when I run a query on an on-change history tag with natural I will get:

image

and fixed with no interpolation I get what I expect

image

If I add another tag with “natural” “min/max” it adds in the extra lines as expected

image

but if I change this from natural to “fixed” “min/max” (which is what I use for charts in order to keep them reasonably responsive) it starts dropping the end values which shows up as missing data (note that the time is not across all values, it appears to have just ignored the end values before converting to “fixed” and using the truncated time range).

image

Now here is where it gets weird.

If I add in a fixed interval tag (shown below in realtime natural)

image

it actually starts interpolating even with the interpolation off (although it gives slightly different results)

“fixed” “min/max” with interpolation on

“fixed” “min/max” with interpolation off

image

This is causing havoc with my charts as well as analysing historical data which is pulled out as all of the step changes (setpoints for example) are shown with linear gradients and any calculations based on this historical data all comes out incorrect as it’s taking an interpolated datapoint.

Any idea on how to fix this?

1 Like