---
title: "Rollup Tag Switch"
slug: "rollup-tag-switch"
updated: 2024-02-05T17:12:33Z
published: 2024-02-05T17:12:33Z
canonical: "kb.dataparc.com/rollup-tag-switch"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.dataparc.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Rollup Tag Switch

A switch can be added to a UTag that will direct PARCview to retrieve PARCrollup Server data instead of data from the native source. Only tags from a .NET data source are compatible with the rollup switch. To access rollup data, add the extension "/ROLLUP("Aggregate", "Period", "Grade", "RunSourceUTag")" (case insensitive) to the end of the UTag, where "Aggregate", "Period", "Grade", and "RunSourceUTag" are replaced by a valid argument.

Example: Mill.PM1.BWT.PV/ROLLUP("AVERAGE","H","13045", "")

The [Build Rollup Tag](/v1/docs/tag-options) tool within the dataPARC Excel Add-in can be used to add the switch to the UTag.

### Aggregate

Aggregate defines the statistic to be returned. Possible values are:

**Average**: FAverage

**RawAverage**: FRawAverage

**Count**:FCount

**Delta**: FDelta

**Min**: FMin

**Max**: FMax

**RunStart**: FRunStart

**RunEnd**: FRunEnd

**RunTime**: FUpTime

**Quality**: FQuality

**RawStdDev**: FRawStdDev

**StdDev**: FStdDev

**StDev**: FStDev

**Product**: FSubRunStdDev

**GradeName**: FGradeRunStdDev

### Period

**D**: Day

**GRADE**: Grade Run

**PD**: Production Day

**M**: Month

**PM**: Production Month

**H**: Hour

**PROD**: Product Run (such as a batch or reel)

**Y**: Year

**W1**: Week Starting on Monday

**W2**: Week Starting on Sunday

**PW**: Production Week

Valid period types depend on which periods are configured for rollup for a given tag’s process unit and are configured in the **Process** tab of [System Configuration](/v1/docs/parcview-system-configuration).

![](https://cdn.document360.io/59db2ca4-e512-446a-a143-a7c626447812/Images/Documentation/image029_013.jpg)

Additional period types can be created in the Time Groups and Time Periods tabs of System Configuration.

### Grade

If set to "", all runs will be returned, otherwise only runs for the specified grade will be returned.

### RunSourceUTag

If set to "", the grade tag for the tag’s process unit will be used. If a process unit is configured with multiple run source tags, the RunSourceUTag can be set to one of the secondary run source tags to access those statistics.

If the RunSourceUTag is not defined, the dataseries must look up the grade tag for the tag’s process unit, and set the RunSourceUTag to the process’s grade tag or NULL if it is not defined.