Skip to main content

Varicent ELT Assistant

Running average

Use the Running average tool to calculate a running average for a column. Adds a new column that returns the running average of the value columns you specify. Use when you want to calculate a running average for a column.

For example, you want to find a particular occurrence of a specific attribute. First, add a count. Use the Formula tool to add a value of "1" to each record in your dataset. This step helps to track each entry. Next, rank your data. Apply the Running Total tool and group your data by the attributes that you want to sort. This helps you rank the entries in either ascending or descending order, based on your chosen attribute. Finally, refine your data. After you rank your data, you have two options: one is to use the Formula tool again and apply a Min/Max formula to pinpoint the exact occurrence. The second one is to use the Filter tool to zero in on the specific running total value that you're seeking.

Group by is an optional configuration.

Input

The Running average tool requires one data set.

Configuration

Use the following configuration options to help create your case configuration.

Configuring the Running average tool

  1. Go to the Pipes module from the side navigation bar.

  2. From the Pipes tab, click an existing pipe to open, or create a new pipe. To create a new pipe, read the Creating a pipe documentation.

  3. In the Pipe builder, add at least two data sources to your pipe. For more information on adding a data source, see the Data Input tool.Data Input

  4. Click symon_add_icon.png + Tool.

    The Tools modal opens, where you can add tools, such as the  Aggregate  tool, to your pipe.

  5. In the Tools modal, search for Running average and then click + Add tool.

    Tip

    You can also find the Running average tool in the Calculate section.

  6. Click the tool node and drag the line to the next tool to connect the tools. If you need to undo the action, click the line and then click Unlink.

  7. In the configuration pane, enter the following information:

    Table 46. Running average tool configuration

    Field

    Description

    Value columns

    Select the numeric columns from your dataset to use to calculate a running average.

    Group columns

    Select the text columns to group together in your dataset.

    Sort by

    Select the column that you want to sort by.

    Sort direction

    Choose the direction to sort your data in, either ascending or descending.

    + New sort criteria

    Click to add another sort criteria to your data.