Add a "Total" or "Subtotal" to a Simple Dimension

This functionality is available for dimensioned:

  • Metrics in any system version,
  • Reports sourced from Datasets in version 5.1.2 and further.

At the Dimension level, an Administrator can include a Total that accumulates all data for each Measurement Time. For Dimensioned Metrics and Reports, this results in a "Total" tile at the Homepage and a "Total" View in the generated in the Metric / Report Viewer.  

At a Dimensioned Metric level, you can exclude the display of the total tile and chart if it does not "make sense" for a specific Metric.

This article covers the following topics:

1. Switch on the "Total" for a Dimension

To switch on the "Total" for a Dimension:

  1. Access the Dimension Editor > Info tab
  2. Set Include "total" Dimension Value to 'yes'

The "Total" Value is going to be added to the Metrics which use this Dimension (in any system Version) and Reports (in version 5.1.2 and further).

2. Configuring the display of a "Total" Dimension Value

The "Total" Dimension Value is shown in 2 places:

  • on a Report / Metric Viewer,
  • on a Homepage as a separate tile (optional).

Both options are described below.

Display on a Report / Metric Viewer

To set up the display of a "Total" Value on a Report / Metric Viewer:

  1. Navigate to the Dimension Editor > Advanced tab
  2. Place "total" Dimension Value: Specify the position of the Dimension value aggregating total results: either "last", or "first".

Save your changes.

On the example above the Dimension Total is displayed last.

Display on a Homepage

To specify whether the Total tile should be displayed at the Homepage:

  1. Open the Dimension Editor > Info tab
  2. In the Dimension Value table find the "Total" field. Click the Gear icon and specify whether the "Total" for a Dimensioned Metric or Report should be shown as a separate tile on a Homepage.

3. Report sourced from a Dataset: "Total" Dimension Value and additional settings

This option is available to Reports sourced from Datasets only and the "Total" Dimension value must set at the Dimension level.

Since the "Total" Dimension value is switched on and off on a Dimension level, we offer an ability to set configure its behavior for each Report individually. To do that:

  1. Access Report Editor > Advanced tab,
  2. In the For Totals field choose one of the options:
    • "Do not generate a report": "total" aggregation will not be shown neither in the Report Viewers, nor at the Homepage.
    • "Show rows for individual values":  displays all rows for all dimensions.
    • "Aggregate numeric values for all values": aggregates all numeric amounts - works like current "total" aggregation.

4. Adding a Subtotal Dimension value

Сustom Subtotal Dimension Value aggregating the data of several selected Dimension Values can be created within a Dimension.

NOTE: The Subtotal Dimension Value can be added only if the 'total' dimension value has been already created for this Dimension.

In our example, instead of reviewing daily sales data for all countries (Dimension Values) within a 'Country' Dimension, a client may create a dimension value aggregating the data of those countries which are a part of European Union:

  1. Click [+ New Dimension Value]
  2. The Add Dimension Value pop-up opens
  3. Define this Dimension value as "Aggregate"
  4. Provide the dimension value with a descriptive Name
  5. Specify whether this aggregate Metric should be shown as a separate tile at the Homepage

Save your entry.

4.1. Specify Dimension Values that should be included

  1. Click Add Content
  2. The Add Content to Custom Total pop-up opens
  3. Check the boxes for Dimension Values whose data should be aggregated for a new common value
  4. Click Add Selected

4.2. Save the changes made

4.3. A new Chart with aggregated data is now available in the Dimension Values drop-down list and at the Homepage