• State Verified Answer
  • Replies 6 replies
  • Subscribers 3 subscribers
  • Views 205 views
  • Users 0 members are here
Options
Related

How to retrieve selective step data points?

sreasbeck

In excel, how would I pull only the Pi data points I have highlighted in the graphic attached? I'd like to filter the zeros out but I can't filter all duplicates, only a duplicate data point on the right side of the plateau if the left side is the same. I don't need timestamps. Just the left side of the plateaus I'm looking for. I'm looking to output these numbers for a 24 hour span from 6-6 daily for all points. The times at which these certain points arise is random. The ups and downs can be much tighter or wider depending on production speeds.

Thanks
Screenshot 2024-04-10 161307.jpg

Parents
  • 0

    If you're able to create an analysis in AF, it would be easy to create a calculated tag that only returns these yellow points. Then you could pull that tag into Excel and use it. That would be my recommendation!

    If you still want to attempt making this in Datalink, I'd look towards the Compressed Data function and try to use a filter. If you know the archive value is always 0 before the desired point, you could add this to the Filter field: PrevVal('YourTag','*')=0

  • 0 in reply to Community User

    Hi Ansle maybe I could trouble you for one more similar question. Let's say I wanted to pull data when the in-between values are not zero, how would I filter these specific points? (like in yellow). Thanks

     


    image.png

  • 0 in reply to sreasbeck

    Hi.

    If you can provide a set of rules on how to accomplish picking the yellow points, perhaps it's easier to answer!

     

    Is it so that you just want the first value for every flat line? That could be solved by changing the tag to be stepped, so you just have vertical and horizontal lines. Then you could add a filter that you just want the values which are different than the previous value, f.ex. PrevVal('YourTag','*')<>'YourTag'

  • 0 in reply to sreasbeck

    Thank you. I have requested IT to look into this tag and they said the stepping was not checked so they did enable it. I'll have to wait and see when we use this tag next time how it registers.

    But yes, I'm interested in the first value of the flat lines and pull these into excel with the Pi datalink.

    I have a another question regarding this same data trends but to filter out the random zero values in addition to the Prevval filter. I'll post it as a separate question thread though.

Reply
  • 0 in reply to sreasbeck

    Thank you. I have requested IT to look into this tag and they said the stepping was not checked so they did enable it. I'll have to wait and see when we use this tag next time how it registers.

    But yes, I'm interested in the first value of the flat lines and pull these into excel with the Pi datalink.

    I have a another question regarding this same data trends but to filter out the random zero values in addition to the Prevval filter. I'll post it as a separate question thread though.

Children
No Data