Skip to Content

Select max Value between two times

I am working on a report that should take the maximum value from each shift. The shift lasts 8 hours. I tried to use the Maximum function ({Data.TagID169}, {Data.TS}), but it gives the maximum value for the day. Can you advise how to solve the problem?
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 13, 2018 at 03:34 PM

    Hi Gala,

    You'd need to Insert a Group on the "Shift" field/formula.

    Then change the formula to:

    Maximum({Data.TagID169}, {Shift_field})

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded