mshrifteylik

Discussions

Beast Mode Help Avg Order Value PoP
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`)) /…
Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.
Our subscription data is collected on multiple days throughout the week and creates a snapshot of that point in time. I want to see what that week's total was based on the most recent day. I don't mind removing the row with an earlier start date.