# Running Total

info

Running Total is not supported for ClickHouse database in Holistics.

## Introduction​

A Running Total is a common calculation method that shows how a metric has changed over time. In Holistics, we use the word "Total" in its boarder sense, which includes: Sum, Average, Min, Max, etc.

For example, you might want to use a running sum to calculate the accumulated amount of goods sold up to a specific quarter. ## How to create a Running Total​

• Drag or type the field's name into the Visualization Settings
• Click on it to display the aggregation drop-down. Here you can choose among 4 currently supported types of Running Total: Sum, Average, Min, Max.
• Click Get Result.

## Mechanism​

A Running Total consists of two main components:

• Running dimensions: The dimensions that the total will “run along” with. Each running direction will have a direction of its own.
• Measures: The measures that you want to calculate the running total.

The following part will give you a detailed look into Running dimensions.

### Running dimensions​

#### Definition​

The running dimensions are the dimensions based on which the measures are aggregated.

Let's take our previous example again: when we calculate the running sum of quantity of goods sold up to a specific quarter, the quarter is the running dimension. It means Holistics will stack up the quantity of goods sold from one quarter to another. note

In this beta version, Holistics auto-selects all the date dimensions as the running dimensions and sorts by the most granular date dimension.

#### Grouping​

The Running Total will be grouped by all non-date dimensions.

Let's say you have a date field, a category field and a running sum of quantity of goods. The running sum will be stacked up by quarter, and grouped by each category. In other words, the Running Total will start all over again for each category. #### Running dimensions and filter​

The running total is re-calculated after the filter/condition is applied to the running dimensions. ### The direction of each running dimension​

The direction of each running dimension determines whether Holistics will calculate the Running Total by ascending or descending order of that dimension. note

In this beta version, Holistics calculates the Running Total in ascending order of all date dimensions in the report. Contact us if you want to change the direction of each running dimension.