Skip to main content

Varicent ELT Help Center

Weighted average

Abstract

Calculates the weighted average of two numeric columns.

Use the Weighted Average tool to discover the average between numeric columns. The tool calculates the weighted average of two numeric columns.

When to use this tool

Use when you want to know the average of two numeric columns.

Configuration

Use the following configuration options to configure the Weighted Average tool.

Configuring the Weighted 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 Weighted Average and then click + Add tool.

    Tip

    You can also find the Weighted 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 47. Weighted Average tool configuration

    Field

    Description

    New column name

    Enter the name of the new column.

    Value column

    Select the numeric column with the value you want to use.

    Weighted column

    Select the numeric column with the value you want to use for the weight.

    Group by

    Select the Group by checkbox if you want to group columns that you specify.