Skip to main content

Symon.AI help center

Date aggregate


Aggregate values grouped by Data columns at a frequency that you specify.

Aggregate values grouped by Date columns at a frequency you specify.

Adds two new columns: a date column and a numeric column.

When to use this tool

Date aggregation can be useful when you're preparing your data for Forecasting.


The Date aggregate tool requires one data input.


Use the following configuration options to help create your Date aggregate configuration.

Configuring the Date 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 Filter. Click Add tool.


    You can also find the Date aggregate tool in the Calculate section.

  5. Connect the tool to your data set.

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

    Table 33. Date aggregate tool configuration



    Date Column

    Select the date column.


    Select the date frequency:

    • Yearly

    • Quarterly

    • Monthly

    • Weekly

    • Daily

    Aggregate column

    Select the column that you want to use to aggregate.


    Select the operation to use:

    • MAX: Use to find the maximum value.

    • MIN: Use to find the minimum value.

    • COUNT: Use to count the value.

    • SUM: Use to find the sum of the value.

    • AVERAGE: Use to find the average value.

    • MEDIAN: Use to find the median value.


    The alias name of the aggregate column.

    Group by

    Select this option to group the Date columns at a frequency you specify.