Beastmode Sales per day to reach goal
My president is asking for a sales dashboard. Total sales for Day, Month, and Quarter. Month and quarters have goals. Based on the sales totals today, how do I figure how many sales we would need per business day to reach our monthly goal, and quarterly goal. Basically he is used to seeing the attached, which also shows the sales for the day/month/quarter. I have used a guage to show them where they are at toward the goal, but they want to take this extra step.
Best Answer
-
Hi @PS-ALW,
Happy to help. If you already have the monthly/quarterly goal and sales, it seems we still need to calculate remaining working days. Once you have the number of remaining working days in the month/quarter, you can then calculate sales per day needed to reach the monthly/quarterly goal. The beastmode calculation for sales needed per day to reach the monthly goal would be something like this:
(`Current Month Goal` - `Current Month Sales`) / `Remaining Working Days in Current Month`
A good way to calculate the remaining working days is to join or stack a calendar dataset with your sales data. This calendar dataset would contain a row for each date, and a column that specifies if each date is a working day. Then you can count the number of working days at the card level for the current month or quarter.
Best,
Domo Diesel
2
Answers
-
Hi @PS-ALW,
Happy to help. If you already have the monthly/quarterly goal and sales, it seems we still need to calculate remaining working days. Once you have the number of remaining working days in the month/quarter, you can then calculate sales per day needed to reach the monthly/quarterly goal. The beastmode calculation for sales needed per day to reach the monthly goal would be something like this:
(`Current Month Goal` - `Current Month Sales`) / `Remaining Working Days in Current Month`
A good way to calculate the remaining working days is to join or stack a calendar dataset with your sales data. This calendar dataset would contain a row for each date, and a column that specifies if each date is a working day. Then you can count the number of working days at the card level for the current month or quarter.
Best,
Domo Diesel
2 -
This looks like it will work. Thank you!
1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 310 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 113 SQL DataFlows
- 652 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 795 Beast Mode
- 78 App Studio
- 44 Variables
- 756 Automate
- 187 Apps
- 480 APIs & Domo Developer
- 72 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive