AnsweredAssumed Answered

Table lookup doesn't show last value when selecting a time range

Question asked by Freytag on Jul 16, 2018
Latest reply on Jan 4, 2019 by Freytag

Hi,

I am facing a strange problem when using the table lookup function with changing parameters. I have a table with the columns date, name of the analysis, values and grade.

Table link:

My table look up looks like this:

 

Here's the thing: If I open the trend, everthing is working fine. But if I set the query days for e.g. the last 2 days, the value shown is not the latest, but something in between the start and end date:

This occures whenever there is a grade change in the selected time range.

Since I want to use these values as single values with multi state together with different trends in PI Vision, this is problematic.

 

Any ideas?

 

Thanks

Tim

Outcomes