Date aggregate
Use the Date aggregate tool to 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.
Go to the Pipes module from the side navigation bar.
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.
In the Pipe builder, add a data source to your pipe. For more information on adding a data source, see the Data Input tool.
Click
+ Tool.The Tools modal opens, where you can add tools, such as the Aggregate tool, to your pipe.
In the search bar, search for Date aggregate. Click + Add tool.
Tip
You can also find the Date aggregate tool in the Calculate section.
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.
In the configuration pane, under Date Column, select the date column.
Under Frequency, select the date frequency:
Yearly
Quarterly
Monthly
Weekly
Daily
Under Aggregate column, select the column that you want to use to aggregate.
Under 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.
Under Alias, enter the alias name of the aggregate column.
Click the Group by to group the Date columns at a frequency you specify.
Click on the tool name to rename your tool node to a meaningful name. Name your tools in a way that describes the function, not the object or the data action. For example, use “Look up rate” instead of “Join to rate table”.