TimeLT

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

Syntax

TimeLT(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 a given value

Exceptions

None

Notes

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

Bad values are excluded from TimeLT calculation

Example

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

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

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

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

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