Beast Mode Help Avg Order Value PoP

mshrifteylik
mshrifteylik
in Charting

I'm trying to calculate the average order value and make a percentage to compare to it last year. Below is the beast mode, I've been trying to use. I have the Domo dimensions calendar hooked up to this flow.


(SUM(`Current Gross Sales`) / COUNT(`Current Orders`)

-

SUM(`Last Year Gross Sales`) / COUNT(`Last Year Orders`))

/

SUM(`Last Year Gross Sales`) / COUNT(`Last Year Orders`)

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Instead of using count for your orders you need to sum them instead.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Instead of using count for your orders you need to sum them instead.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories