Running total
The Running total tool calculates an accumulating total for a column. Adds a new column that returns the running total of the value of columns you specify.
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.
Input
The Running total tool requires one data input.
Configuration
Use the following configuration options to help create your Running total 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 Pipe builder, add your data source.
Click
+ Tool.
In the search bar, search for Running total. Click + Add tool.
Tip
You can also find the Running total tool in the Calculate section.
Connect the tool to your data set.
In the configuration pane, under Value columns, select one or more columns for which you want to calculate an accumulating total.
Under Group columns, select the column(s) to group into. Group similar data columns together so that you can sort similar attributes.
Under Sort by, select the column that you want to use to create a new running total column for.
Under Ascending - Descending, switch the toggle to sort your data either in ascending or descending order.
Note
The default sort is descending, which results in totals accumulating backwards in time.
Optionally, click +New Sort Criteria to add another column to sort the running total for.