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

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

Best Answers

  • MichelleH
    MichelleH Coach
    edited May 28 Answer ✓

    @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
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • MichelleH
    MichelleH Coach
    edited May 28 Answer ✓

    @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

  • 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.

  • @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
    GrantSmith Coach
    Answer ✓

    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.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • Great. That's worked. Thank you Michelle & Grant.