Skip to main content

Symon.AI help center

Aggregate

Abstract

Summarize data by aggregating.

Summarize data by aggregating.

The aggregate operations are: MAX, MIN, COUNT, SUM, AVERAGE, MEDIAN, OR, AND, and STDEV.

You can use the OR and AND functions only with columns that contain Boolean values. The tool returns TRUE if:

  • OR is used and at least one record is true.

  • AND is used and all records are true.

Tip

You can use the COUNT operation without selecting an aggregate column.

When to use this tool

Use this tool when you want to:

  1. Perform an aggregate operation on a column.

  2. Arrange data into groups.

  3. Arrange your data into groups AND apply an aggregate operation.

Configuration

Use the following configuration options to configure the Aggregate tool.

Configuring the Aggregate tool
  1. In Pipe builder, add your data source.

  2. Click symon_add_icon.png +Add Tool.

  3. Click See all tools.

  4. In the search bar, search for Aggregate. Click Add tool.

    Tip

    You can also find the Aggregate tool in the Calculate section.

  5. Connect the tool to your data set.

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

    Table 29. Aggregate tool configuration

    Field

    Description

    Aggregate columns Group by

    Select the Group by checkbox if you want to group the aggregate columns by a specific existing column.

    Column

    Select the column to use from the drop-down menu.

    Sum

    Select the sum to use from the drop-down menu.

    Column name

    Enter a name for the column.



  7. (Optional) Add additional aggregate columns.

Usage example

Let's use the aggregate tool to return the total row count for our data set.

  1. Leave the Grouped columns and Aggregate columns fields blank.

  2. Type a name for the new column.

  3. In the Operation field, select COUNT.