• State Not Answered
  • Replies 3 replies
  • Subscribers 3 subscribers
  • Views 335 views
  • Users 0 members are here
Options
Related

Does anyone know if there is a PI Datalink function to return a timestamp when a historian point equals a certain value?

bpomerhn

Specifically, I'm trying to populate a regulatory excel report with a bunch of lab data that I'm taking in through string and numeric inputs in FT.

I'm trying to look at the timestamp for the integer that is the date associated with the lab data. Then I will pull the associated data for other historian points in that same range of time (the data all gets moved or copied at one time by the PLC in a couple of seconds). The operators/lab techs get caught up entering multiple days at one time, or I'd just look at each days' value.

Nothing stuck out at me in the PI Datalink manual.

Parents
  • 0

    If I understand your goal correctly, I often do this with a Compressed Data retrieval looking for one value. Essentially, start looking (forward or backward) from a time and filter for the desired Boolean trigger.

     

    You can daisy chain so the next look begins at the previous find.

     

    =PINCompFilDat("Tag.PV","t",1,"'Tag.PV' <140",0,1,"\\server","inside")

     

    Select Number of values

    Start time = t (today)

    Number of values = 1

    Filter expression = 'Tag.PV' <140

    Check Show Timestamps

    Apply/OK!

Reply
  • 0

    If I understand your goal correctly, I often do this with a Compressed Data retrieval looking for one value. Essentially, start looking (forward or backward) from a time and filter for the desired Boolean trigger.

     

    You can daisy chain so the next look begins at the previous find.

     

    =PINCompFilDat("Tag.PV","t",1,"'Tag.PV' <140",0,1,"\\server","inside")

     

    Select Number of values

    Start time = t (today)

    Number of values = 1

    Filter expression = 'Tag.PV' <140

    Check Show Timestamps

    Apply/OK!

Children
No Data