Skip to content

    • Cards, Dashboards, Stories

    Cards, Dashboards, Stories

    Beast Mode wrongly gives 0 as answer

    Member
    in Cards, Dashboards, Stories

    My simple beast mode SUM(aprobado) / SUM(ingreso_mesa) returns 0 in all cases

    image.png

    Please help

    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

    Answers

    • Contributor

      Hi @Juan_Coronel_221b. Welcome to the Domo Community. You'll love it here.

      You don't want to aggregate each column that goes into your beastmode when you are looking at line-by-line, as in your screenshot.

      Remove the SUM() that precedes each column, and that will give your 0 column values.

      Like so:

      aprobado / ingreso_mesa

      ✅Did this solve your problem? Accept it as a solution!

      ❤️Did you love this answer? Mark it as "Awesome"!

      👍Do you agree with this process? Click "Agree"!

    • Member

      Thanks a lot Devon, we try but it sends an error message

    • Contributor

      Make sure you wrap it in backticks :

      ` aprobado ` / ` ingreso_mesa `

      ✅Did this solve your problem? Accept it as a solution!

      ❤️Did you love this answer? Mark it as "Awesome"!

      👍Do you agree with this process? Click "Agree"!

    • Member

      Hi Devon, we did try formatting it as

      ` aprobado ` / ` ingreso_mesa `

      but it's still not producing the expected result

    • Member

      Actually, something strange happened. In our urgency to find a solution, we tried some unconventional options. One of those was to reverse the formula order, using:

      SUM(ingreso_mesa) / SUM(aprobado)

      While this is an incorrect calculation, it surprisingly produced a non-zero result

      image.png
    • Coach

      Hi @Juan_Coronel_221b

      Can you share a screenshot of the card configuration as well?

    • Contributor

      Make sure you format the original calculation column as a percentage:

      1. click the column that has your intended calculation
      2. click format
      3. click display as Percentage
      image.png

      All of those values resolve to a number less than 1. The table will default to show 0, unless you tell it to treat it as a percentage

      ✅Did this solve your problem? Accept it as a solution!

      ❤️Did you love this answer? Mark it as "Awesome"!

      👍Do you agree with this process? Click "Agree"!

    • Member

      I ggenovese

      the beast modes are

      image.png
      image.png
      image.png
    • Member

      I Devon

      let me show you we, try with that format

      image.png
    • Coach

      Hi @Juan_Coronel_221b

      Can you try giving the beat mode a different name, one that starts with a letter instead of a symbol? Also can you add a total row, does it give 0% as the total too?

    • Member

      Hi

      Just wanted to give you all an update on this card

      We found a fix that seems to be working

      Here's the Beast Mode fix we put in:

      CAST (SUM(`aprobado`) AS DECIMAL ) / CAST (SUM(NULLIF(`ingreso_mesa`,0)) AS DECIMAL)

      The cards look like they're working now, but we want to keep an eye on them for the next days to make sure everything's good.

    • Member
      image.png
    • Member
      image.png

    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