Report module Tag History Query Closest Value

Ignition
1

How do I get the value closest to the end of the time range?

Closest value seems to be getting the value closest to the start instead of the end for me.

The historized tag is historized once an hour.

On the report I am looking at the tstamp and the values.

image

These are values and timestamps I pull the data source to a table.
image

This is what I am receiving when I specify the specific data.
image

@levels.test01@

This is why I had expected the last value instead of the first when set to closest value.

image
image805×69 2.66 KB

8.1.39

I am pretty sure that I am setting up the configuration wrong.

2

Or how do I subquery the tag history query data source so that I can just get the top 1 where tstamp is descending?

For now I just set the range as the last hour of the actual range so even if it gets the closest value as the early value instead of most recent, at least that is the latest hour of the range. Not ideal, but not sure how to make it fetch the last value.

3

This ClosestValue option is working terrible.

Is LastValue going to be added as an option?