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

Options

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 ✓
    Options

    @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 ✓
    Options

    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 ✓
    Options

    @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
    Options

    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
    Options

    @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 ✓
    Options

    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!**
  • Charlie Bantoft
    Options

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