Percent of Total

Feature Prerequisites

• 4.0 Version: If you are currently using version 3.0, you'll need to upgrade to 4.0 version to use this feature and other cool stuff.
• AQL-Enabled: Once your version is upgraded to 4.0, make sure you have enabled AQL for your datasets.

Alternative

This is the built-in, UI-centric functionality to calculate the Percent of Total. Alternatively, you can use AQL expressions with the of_all() function as detailed here: Calculate Percent of Total using AQL.

Percent of Total allows you to see the distribution of a measure by specific dimensions, such as sales percentages by country or by product category.

Percent of Total is supported in various visualizations:

• Table
• Pivot table
• Line chart family including line, column, bar, area, and combination charts
• Metric sheet

For the best presentation of your analysis, we recommend using it in a table or a pivot table.

In this video, we walk you through how to create the Percent of Total in both a table and a pivot table, using grand total, row total, column total, and custom total: