Skip to main content

Varicent ELT Help Center

Running average

Abstract

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.

The result is sorted based on another column you specify.

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 one data source to your pipe. For more information on adding a data source, see the Data tool.

  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 44. 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.