Asset analytics expression functions by type

The following list contains links to asset analytics expression functions by type.

Array operations

• ArrayLength

• FilterData

• FirstValue

• LastValue

• MapData

Date and time

• Bod

• Bom

• Bonm

• Day

• DaySec

• Hour

• Minute

• Month

• Noon

• ParseTime

• Second

• Weekday

• Year

• Yearday

Event frame properties

• EventFrame

Logical

• AND

• ELSE

• Exit

• IF

• IN

• NOT

• OR

• THEN

Math

• Abs

• Acos

• Asin

• Atn

• Atn2

• Ceiling

• Cos

• Cosh

• Cot

• Coth

• Csc

• Csch

• Curve

• E

• Exp

• Float

• Floor

• Frac

• Int

• Log

• Log10

• Logbase

• Mod

• Pi

• Poly

• Pow

• Rate

• Remainder

• Round

• Roundfrac

• Sec

• Sech

• Sgn

• Sin

• Sinh

• Sqr

• Tan

• Tanh

• Trunc

Operators

• Mod

PI Data Archive digital states

• DigState

• DigText

• StateNo

Point attributes

• TagDesc

• TagEU

• TagExDesc

• TagName

• TagNum

• TagSource

• TagSpan

• TagType

• TagTypVal

• TagZero

Search and retrieval

• Convert

• DeltaValue

• FindEq

• FindGE

• FindGT

• FindLE

• FindLT

• FindNE

• InterpolatedValues

• NextEvent

• NextVal

• NumOfChanges

• PrevEvent

• PrevVal

• RecordedValues

• RecordedValuesByCount

• SecSinceChange

• TagVal

• TimeEq

• TimeGE

• TimeGT

• TimeLE

• TimeLT

• TimeNE

• TimeStamp

Statistical

• Avg

• Compare

• Max

• Median

• Min

• Normalrnd

• Poisson

• PStDev

• Rand

• SStDev

• Total

Status

• BadVal

• HasChanged

• HasValueChanged

• IsSet

• NoOutput

• TagBad

String

• Ascii

• Char

• Compare

• Concat

• Contains

• Format

• InStr

• LCase

• Left

• Len

• LTrim

• Mid

• Right

• RTrim

• Split

• String

• Text

• Trim

• UCase

Time series value statistics

• Cov

• EventCount

• LinRegr

• PctGood

• Range

• StDev

• TagAvg

• TagMax

• TagMean

• TagMin

• TagTot