Setting up Totals in the Aggregator Panel

  • 21 December 2021
  • 0 replies
  • 1311 views

Userlevel 5
Badge +3

You can choose to visualize your data in a specific way in any Block (List, Metric or Table), which is referred to as a view. Use aggregators to set up totals and sub-totals on your view. If you have the appropriate application permissions, you can save your views to refer back to them later.

 

Table of Contents

 

Adding a Total

 

To add a total, click on the Σ icon. The default total is Sum for all Metrics listed in the rows and columns as well as all dimensions, including those that are hidden or used as Page Selectors.

The first Metric is shown as expanded so you can view all the dimensions and their aggregators. 

You can choose to add totals to one or all Dimensions suggested. To identify the hidden dimension(s), hover your cursor over the non-time dimension label.

Once you are done, don't forget to save your View, so that you can go back to it even after you've made changes to your Block.

 

 

Change the aggregator for a dimension and copy it to all Metrics sharing that dimension.

 

Click to remove the aggregator

 

To update the view, click Apply.

 

Note that aggregations are performed in this order: non-time Dimensions first then the other Dimensions.

 

If you have the appropriate application permissions to save changes to a view, you'll see a Save button in the upper-right corner. If not, the changes you make to the view are not saved when you close it.

 

If an item is filtered out, it will not be included in the total.  For example if I am looking at Revenue, and I add a filter that excludes France.  The Total will not include France.

 

Types of totals

 

Depending on the data type of Metric, there are different ways to calculate totals.

 

Aggregator Data Type 
SUM: calculates the sum of a Dimension Number, Integer 
AVG: calculates the average of a Dimension Number, Integer 
MIN: calculates the minimum value of a Dimension Number, Integer, Date 
MAX: calculates the maximum value of a Dimension Number, Integer, Date 
Count: counts the number of values of a Dimension Number, Integer, Dimension, Date, Text 
Count all : counts the number of items within a Dimension  Number, Integer, Dimension, Date, Text 
Count Blank: counts the number of blank items within a Dimension  Number, Integer, Dimension, Date, Text 
Count Distinct: counts the number of different items within a Dimension  Number, Integer, Dimension, Date, Text 
First: shows the first cell of a Dimension  Number, Integer, Dimension, Date, Text 

First Non Blank: shows the first value of a Dimension 

Number, Integer, Dimension, Date, Text 
Last: shows the last cell of a Dimension  Number, Integer, Dimension, Date, Text 
Last Non Blank: shows the last value of a Dimension Number, Dimension, Date, Text 

 

Total for Boolean Metrics 

 

  • Any: returns true if at least one of the elements is true

  • All: returns true if all the values are true or false.  It is important to note that Blank state Booleans will be ignored, see image below.

  • First : returns the state of the first item within the dimension, for example, January in a 1-year month dimension. 

  • First Non Blank: returns the state of the first item that is not blank

  • Last: returns the state of the last item within the dimension, for example December in a 1-year month dimension.

  • Last Non Blank: returns the state of the last item that is not blank

 

When working with Boolean Totals, remember that there are three states in booleans.  Blank, True or False as shown here.

 

Display options: Show every subtotal

 

To display subtotals for dimensions, turn on the Show every subtotal toggle at the bottom of the View Aggregators panel.

In the following example, the Metric is composed of two dimensions, Country and Products.  The Metric on the left has subtotals turned on, which allows you to see the totals for each product, along with the total for all products and countries.  While the Metric on the right shows the total for countries and products because the Show every subtotal toggle switch is turned off. 

 

 

 


This topic has been closed for comments