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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 468 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 173 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive