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
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 298 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive