Keep beast mode field calculated on total value when filtered

jessewh

I am creating a beast mode filters which shows me the percentage of the total units by person but when I filter out people the percentage changes to only calculate on the current people in the filter. Is there a way to keep the original numbers and show those on the card while filtering?

MarkSnodgrass

You are going to want to add a fixed function into your beast mode. Look at this KB article on how to do it, specifically the Filter None section.

https://domo-support.domo.com/s/article/4408174643607?language=en_US

ArborRose

If you use something like

(SUM(units) OVER (PARTITION BY person) / total_units) * 100

It should keep the % constant regardless of filtering.

MarkSnodgrass

You are going to want to add a fixed function into your beast mode. Look at this KB article on how to do it, specifically the Filter None section.

https://domo-support.domo.com/s/article/4408174643607?language=en_US

ArborRose

If you use something like

(SUM(units) OVER (PARTITION BY person) / total_units) * 100

It should keep the % constant regardless of filtering.

GrantSmith

Agree with @MarkSnodgrass, FILTER NONE option on a FIXED function will allow you to filter your original data but keep the entire dataset as part of the calculation.