SUM('Revenue') BUT IGNORE ALL FILTERS PLEASE!!!

Charlie Bantoft

Hi all

About to through my Mac through the window if I can't sort this.

How do I write a Beast Mode that sums data whilst ignoring ALL filters?

Many thanks

MichelleH

@Charlie Bantoft You can use a FIXED function in Beast mode so your calculation ignores filters like this:

sum(sum(`Revenue`)) FIXED (by `Dimension` FITLER NONE)

More on Fixed functions: https://domo-support.domo.com/s/article/4408174643607?language=en_US

GrantSmith

Dimension is how you want your totals to be bucketed. If you want it across your entire dataset you can remove the by Dimension portion of the fixed function.

MichelleH

@Charlie Bantoft You can use a FIXED function in Beast mode so your calculation ignores filters like this:

sum(sum(`Revenue`)) FIXED (by `Dimension` FITLER NONE)

More on Fixed functions: https://domo-support.domo.com/s/article/4408174643607?language=en_US

Charlie Bantoft

Thank you, Michelle. What goes in the place of 'Dimension', please ? I just want to sum all revenue - not filtered by any given dimension. Thanks again.

MichelleH

@Charlie Bantoft The Dimension should correspond with whatever field you are use to group your data in the card, like Customer. If your card is not grouping by any specific field, then you can remove "by Dimension" and just have "FILTER NONE" in the parenthesis.

GrantSmith

Dimension is how you want your totals to be bucketed. If you want it across your entire dataset you can remove the by Dimension portion of the fixed function.

Charlie Bantoft

Great. That's worked. Thank you Michelle & Grant.