How to chart a running total

Data Pipeline

Charting a running total of your data is easy to do in our Data Pipeline.

First, open your existing chart or create a new chart. At minimum, you’ll need the measure you’d like to keep a running total of, and a dimension. For your dimension, use a date with a time bucket of your choice. Once you’ve dragged and dropped your selections, click Select Data.

In this example, we are using the sum of Payments for the Measure, and a month of Payment Date for the Dimension.

Example, sum of Payments for Measure and month of Payment Date for Dimension

In your Data Pipeline, click Add Step and choose Add Column. Name your column, select Running total as your formula type, and select the column you’d like to take a running total of.

Add Column in the Pipeline

In the Create Chart section, choose the line chart icon, and add your desired chart labels. Click apply, then scroll to the top and click Save.

Running total final result

Related Data Pipeline Help Articles

See more