Contents x
    Aggregates
    • 30 Jan 2024
    • Print
    • PDF
    Contents

    Aggregates

    • Updated on 30 Jan 2024
    • Print
    • PDF
    Article summary

    PARCview can return aggregated tag data without requiring users to create a new calculated tag. Aggregates are requested by appending a “tag switch” to a fully qualified UTAG name: Location.Source.TagName/TagSwitch.

    The main aggregate tag switches can be categorized as follows:

    • Trend: These tag switches only apply in Trend displays.

    • Fixed: The Fixed aggregates are calculated over fixed intervals, specifically the seconds, minutes, and hours of the day, and days of the year.

    • Relative: Relative aggregates are calculated over a given timespan from an arbitrary starting point, typically the start time of Trend displays.

    • Aligned: Aligned aggregates are calculated over a given timespan from a specified time of the day, such as “7:00” for 7 AM.

    The following is a table of tag switches used to request aggregated data.

    Category

    Tag Switch

    Syntax

    Description

    Trend

    /PLOT

    No additional syntax required

    Instructs Trend to return plot-reduced data set for tag. Automatically applied when a tag is added to a trend.

    Trend

    /RAW

    No additional syntax required

    Instructs Trend to return raw data for a tag. Same result as removing /PLOT from a tag.

    Fixed

    /DAY

    No additional syntax required

    Returns a time-weighted average calculated from 12:00 AM to 12:00 PM, not including the end time.

    Fixed

    /HOUR

    No additional syntax required

    Returns a time-weighted average calculated from the beginning of the hour (1:00, 2:00, etc.) to the end of the hour, not including the end time.

    Fixed

    /MINUTE

    No additional syntax required

    Returns a time-weighted average calculated from the beginning of the minute to the end of the minute (5:45-5:46, etc.), not including the end time.

    Fixed

    /SECOND

    No additional syntax required

    Returns a time-weighted average calculated from the beginning of the second to the end of the second (5:45:07-5:45:08, etc.), not including the end time.

    Relative

    /AVG

    /AGGREGATE=INTERVAL
    e.g. /AVG=5M

    Returns the arithmetic average calculated over the interval. Specify the interval as a function of a number plus a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /TAVG

    /AGGREGATE=INTERVAL
    e.g. /TAVG=5M

    Returns the time-weighted average calculated over the interval. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /I

    /AGGREGATE=INTERVAL
    e.g. /I=5M

    Returns an interpolated value calculated at the start time of the interval, based on the tag's interpolation mode. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /MIN

    /AGGREGATE=INTERVAL
    e.g. /MIN=5M

    Returns the minimum value within the interval. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /MAX

    /AGGREGATE=INTERVAL
    e.g. /MAX=5M

    Returns the maximum value within the interval. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /STDEV

    /AGGREGATE=INTERVAL
    e.g. /STDEV=5M

    Returns the standard deviation within the interval. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Relative

    /TOTAL

    /AGGREGATE=INTERVAL
    e.g. /TOTAL=5M

    Returns the TimeAvg * the interval in seconds. Used for summing rates. The resulting units are normalized to seconds, so a unit conversion is required if the rate uses different units. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days).

    Aligned

    /AVG

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /AVG(5M,7:00)

    Returns the arithmetic average calculated over the interval starting from the align time. Specify the interval as a function of a number plus a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /TAVG

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /TAVG(5M,7:00)

    Returns the time-weighted average calculated over the interval starting from the align time. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /I

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /I(5M,7:00)

    Returns an interpolated value calculated at the start time of the interval starting from the align time, based on the tag's interpolation mode. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /MIN

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /MIN(5M,7:00)

    Returns the minimum value within the interval starting from the align time. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /MAX

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /MAX(5M,7:00)

    Returns the maximum value within the interval starting from the align time. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /STDEV

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /STDEV(5M,7:00)

    Returns the standard deviation within the interval starting from the align time. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Aligned

    /TOTAL

    /AGGREGATE(INTERVAL,ALIGNTIME)
    e.g. /TOTAL(5M,7:00)

    Returns the TimeAvg * the interval in seconds. Used for summing rates. The resulting units are normalized to seconds, so a unit conversion is required if the rate uses different units. Specify the interval as a function of a number followed by a time key letter (S=Seconds, M=Minutes, H=Hours, D=Days), and specify the align time as a time of the day (7:00, 17:30, etc.).

    Was this article helpful?
    What's Next