TimeGT

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

Syntax

TimeGT(attname, starttime, endtime, x)

Arguments

• attname

  The name of an attribute with a PI point data reference, enclosed in single quotation marks

• starttime

  time expression representing the beginning of a time range enclosed in single quotes; can be a relative time (such as '-3h') in reference to an absolute endtime

• endtime

  time expression representing the end of a time range enclosed in single quotes; can be a relative time (such as '+1h') in reference to an absolute starttime

• x

  The reference value of the search; must be an enumeration set (string), integer or real number

Returns

The total time (in seconds), within a range, when an attribute value is greater than a given value

Exceptions

None

Notes

TimeGT interpolates between events, if necessary, to find the times when the attribute value crossed the specified value

Bad values are excluded from TimeGT calculation

Example

• TimeGT('att1', 't', '+1h', 80)

  [Find the total time between 12:00 and 1:00am today when 'att1' was greater than 80]

• TimeGT('att1', '-1h', '*', TagVal('att1', 't+8h'))

  [Find the total time in the past hour when the value of 'att1' was greater than the value at 8am today. Result is in seconds]

• TimeGT('enum_att1', '*-1d', '*', DigState("Normal", 'enum_att1'))