Skip to main content

Varicent ELT Assistant

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.

Configuring the Running total 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 Running total. Click + Add tool.

    Tip

    You can also find the Running total tool in the Calculate section.

  6. Connect the tool to your data set.

  7. In the configuration pane, under Value columns, select one or more columns for which you want to calculate an accumulating total.

  8. Under Group columns, select the column(s) to group into. Group similar data columns together so that you can sort similar attributes.

  9. Under Sort by, select the column that you want to use to create a new running total column for.

  10. 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.

  11. Optionally, click +New Sort Criteria to add another column to sort the running total for.