TimeLE

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

Syntax

TimeLE(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 less than or equal to a given value

Exceptions

None

Notes

TimeLE interpolates between archive events, if necessary, to find the times when the point crossed the given value

Bad values are excluded from TimeLE calculation

Examples

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

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

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

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

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