There is a requirement to get a running total of number of hours an equipment is online over a range of time (from Start to end of the year) and this should auto reset at the Start of every year. There is an exception added to the above requirement that the equipment will be considered online only if it is online for more than 20 Seconds ( to ensure we are not collecting the noise). I wrote an Analysis that calculates the total running hours of equipment (for 1 year) and should reset every year. but struggling with how to remove those time duration which is less than 20 Seconds. For example: Att1, if greater than 10 indicate that the equipment is online but if this condition is true for less than 20 Seconds then this Equipment will not be considered online.
If anyone of you have came across this kind of scenario, please help me.