Knowledge Drop

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

  • 15 June 2021
  • 0 replies
  • 66 views

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.                

 

 


0 replies

Be the first to reply!

Reply