TotalOverTime

This function returns the total of all values whose timestamps are greater than the newest timestamp minus the specified interval.

TotalOverTime ( number, valueTimestamp, interval)

The number parameter specifies the data value for which the total is calculated. The valueTimestamp is the timestamp for this data value. (The Timestamp function can be used to obtain this timestamp.) The interval parameter is the time interval, in nanoseconds, over which the total is calculated. The predefined time constants can be used to easily input the number of nanoseconds in a microsecond (nsecPerUSec), millisecond (nsecPerMSec), second (nsecPerSec), minute (nsecPerMin), hour (nsecPerHour), day (nsecPerDay), or week (nsecPerWeek). Any value that evaluates to –INF, INF, or NAN will be ignored. If there are no valid values stored, this function will return NAN.

The following example will return the total of the variable Rain over the past 24 hours. (The StartRelativeToNewest function backfills the data set initially to the full 24 hour interval, provided that the data is available in the data source.)

StartRelativeToNewest(24*nsecPerHour, OrderCollected); TotalOverTime("Server:CR1000.Hourly.Rain",TimeStamp("Server:CR1000.Hourly.Rain"), 24*nsecPerHour)