Running average
Use the Running average tool to calculate a running average for a column. Adds a new column that returns the running average of the value columns you specify. Use when you want to calculate a running average for a column.
For example, you want to find a particular occurrence of a specific attribute. First, add a count. Use the Formula tool to add a value of "1" to each record in your dataset. This step helps to track each entry. Next, rank your data. Apply the Running Total tool and group your data by the attributes that you want to sort. This helps you rank the entries in either ascending or descending order, based on your chosen attribute. Finally, refine your data. After you rank your data, you have two options: one is to use the Formula tool again and apply a Min/Max
formula to pinpoint the exact occurrence. The second one is to use the Filter tool to zero in on the specific running total value that you're seeking.
Group by is an optional configuration.
Input
The Running average tool requires one data set.
Configuration
Use the following configuration options to help create your case 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 at least two data sources 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 Tools modal, search for Running average and then click + Add tool.
Tip
You can also find the Running average 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, enter the following information:
Table 46. Running average tool configurationField
Description
Value columns
Select the numeric columns from your dataset to use to calculate a running average.
Group columns
Select the text columns to group together in your dataset.
Sort by
Select the column that you want to sort by.
Sort direction
Choose the direction to sort your data in, either ascending or descending.
+ New sort criteria
Click to add another sort criteria to your data.