Build a Roll-up Report / Dashboard Template

Roll-up reporting has many, powerful advantages for grouped reporting to customers and internal monitoring capabilities. There are a few specific settings to fully activate roll-up functionality in your template. This article explains them.

Activate Roll-up Reporting

2. Create a new template or select the desired template from the list

3. Click the globe icon (Template Settings) at the top of the right side inspector panel to open the Template Settings panel. This panel also holds the Template Name, Ignore Global DataSource and Footers settings.

4. Toggle on the "Roll-up Report" switch. It's off by default.

📘

The Roll-up Report switch is in Template Settings

You won't find the Roll-up Report switch in a widget's data settings. It's only in the Template Settings panel (globe icon).

📘

What the Roll-up Report switch does

Turning on Roll-up Report doesn't add accounts to your report by itself. The extra accounts come from the Grouping you set on each data source (see below).

When Roll-up Report is off, a data source only shows data if the account selected in the report has that data source connected. This applies even when a Grouping is set. When Roll-up Report is on, the grouped accounts' data is shown even if the selected account doesn't have that data source connected. Datasets don't have this requirement.

If you turn on Roll-up Report but don't set a Grouping, the report uses only the selected account's data. You won't see an error.

Ignore Global DataSource

Ignore Global DataSource is also in the Template Settings panel. It applies to the whole template. It only controls whether this template appears on an account's Dashboard. It doesn't change the data the template pulls.

A template appears on an account's Dashboard when the account has one of the template's data sources connected. When Ignore Global DataSource is off, global data sources (such as Datasets) count as connected. When it's on, they don't, so the template appears only if the account has one of the template's data sources actually connected. Roll-up templates always appear on the Dashboard, whatever this setting is.

Select a Grouping for Each Data Source

1. Add a widget to the page

2. Follow the instructions in the article Configuring a Data Widget to produce data from the widget

3. After the first step of adding the data source to the widget, click the pencil icon on the data source's row in the widget's Data settings. This opens the Configure Data Source window.

4. Click on the drop-down menu under "Grouping" in the Configure Data Source window

5. Select the Account Group field you want to group by (for example, Region)

6. Click the "Save" button at the bottom right of the Configure Data Source window

📘

If you've got more than one data source in your widget, you'll need to repeat this step for each one.

7. Select an account from the accounts drop-down at the top of your template. The report includes every account that has the same value as this account in the Account Group field you chose. If this account has no value for that field, only its own data is shown.

📘

While you're getting used to roll-up widgets, it's a great idea to include the Account Dimension in your widgets - this will segment the data by account for easy data verification. If you're using multiple data sources, it might be a good idea to use the Data Source Dimension as well to verify your data, especially if you're using aggregate metrics.

8. Click the Save (check-mark) icon near the top right to save your template!

Using a dataset

If your widget uses a dataset, choose the Account Group field in the "Grouping (Optional)" field of the Select a Dataset window when you add the dataset.


Did this page help you?