We have an excel report for MonthToDate calculations, where-in we represent the value of a PI tag for each day. The PI tag is a digital one and we need to represent the status that was for maximum amount of time in that particular day.
Eg:The PI tag has ON/OFF values in it, and for a particular day, if the PI tag had been in ON state for 17 hrs and in OFF state for remaining 7 hrs, the result should be ON.
Do we have a direct datalink function for it? If not please suggest how this can be achieved.
I thought of using FINDEQ/TIMEEQ functions and then applying excel formulae over it to calculate the state that has greater time range , however they seem to be bit complicated when applying for multiple tags.