Skip to content

    • Beast Mode

    Beast Mode

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

    Member
    in Beast Mode

    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

    Tagged:

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Best Answers

    • Coach
      edited May 2024 Answer ✓

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

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

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

    • 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

    • Coach
      edited May 2024 Answer ✓

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

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

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

    • Member

      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.

    • Coach

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

    • 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!**
    • Member

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories