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.
Input
The Date aggregate tool requires one data input.
Configuration
Use the following configuration options to help create your Date aggregate configuration.
In , add your data source.
Click +Add Tool.
Click See all tools.
In the search bar, search for Filter. Click Add tool.
Tip
You can also find the Date aggregate tool in the Calculate section.
Connect the tool to your data set.
In the configuration pane, enter the following information:
Table 38. Date aggregate tool configurationField
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.