Skip to main content

Varicent ELT Help Center

Date aggregate

Abstract

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.

Input

The Date aggregate tool requires one data input.

Configuration

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

Configuring the Date aggregate 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 Pipe builder, add your data source.

  4. Click symon_add_icon.png + Tool.

  5. In the search bar, search for Filter. Click + Add tool.

    Tip

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

  6. Connect the tool to your data set.

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

    Table 36. Date aggregate tool configuration

    Field

    Description

    Date Column

    Select the date column.

    Frequency

    Select the date frequency:

    • Yearly

    • Quarterly

    • Monthly

    • Weekly

    • Daily

    Aggregate column

    Select the column that you want to use to aggregate.

    Operation

    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.

    Alias

    The alias name of the aggregate column.

    Group by

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