We are using pi on excel. Someone please tell me how to calculate total time a certain parameter remains below or above certain limit for a defined time period?

We are using pi on excel. Someone please tell me how to calculate total time a certain parameter remains below or above certain limit for a defined time period?

- 1 person found this helpful
Hi Abad

If you are using analysis then request you to use

Find the total time, within a range, when an attribute value is greater than a specified value. Time returned is in seconds.

TimeGT(attname, starttime, endtime, x)

Find the total time, within a range, when an attribute value is less than a specified value. Time returned is in seconds

TimeLT(attname, starttime, endtime, x) functions.

Thanks,

Lal

Hi Abad Shan,

You can try using

Time filtereddata option for your requirement, please find the below query for your reference.=PITimeFilterVal("'sinusoid' <5","*-5d","*","hours",0,"server name")

The query is checking the total number of hours in last 5 days for the tags sinusoid when the value is less than 5.

Let me know if this helps.