Skip to content

    • Charting

    Charting

    Sum Count(Distinct) Sales vs Budget

    Member
    in Charting

    Hello All! I'm trying to do Total Sales divided by Total Monthly Budget in beast mode. The correct output should be $150/$500 but DOMO sum all lines under Budget column that gives out $150/$1300.

    I tried Sum(count(distinct 'Store'), 'Monthly Budget') but no luck. Any solution?

    image.png


    Tagged:

    Answers

    • Coach

      You could use Magic ETL to group by store and month, and do a sum of Sales and maximum of Monthly Budget (assuming it stays the same the whole month). This would give you an output like this:

      A May $120 $300

      B May $30 $200

      Then in your card just use a beast mode to calculate sales as percentage of budget.

      **Was this post helpful? Click Agree or Like below**

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

    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