Why does my Percent of Total (percent_of_total) measure show up as null?

Knowledge Drop

Last tested: Jul 11, 2019
 

Explanation

A percent_of_total measure is basically a table calculation, which means it's not run on the database. Therefore, if the row limit is hit, the total can't be properly calculated.

Solution

Increase the row limit to the max (5000).

If you have more than 5000 rows, then this will require a derived table instead.

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 06:15 PM
Updated by: