Can percent_of_total type measures be referenced in number type measures?

Knowledge Drop

Last tested: Jan 21, 2019
 

No they cannot: As mentioned here https://docs.looker.com/reference/field-reference/measure-type-reference#percent_of_total

percent_of_total measures are calculated after data is returned from your database. This means that you should not reference a percent_of_total measure within another measure; since they might be calculated at different times, you may not get accurate results. It also means that percent_of_total measures cannot be filtered on.

This content is subject to limited support.                

Version history
Last update:
‎04-05-2021 03:17 PM
Updated by: