Sum Count(Distinct) Sales vs Budget

johnlam1
johnlam1
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

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

Categories