Average based on Months Passed and Months left in year
Hello,
Looking to take a goal I have already calculated and be able to show how much is needed on average per month until the end of the year. Additionally, calculate the average based on months passed.
An example would be a goal of 500 topics posted during the year and currently there are 250 topics posted. I have an ETL that calculates how many I need, in this example 250 topics to be posted to reach the goal. From there how can I show that with 2 months left in the year I would need 125 topics posted per month ie. Topics needed/months left in year.
Secondly, how can I show the average amounts of topics posted in the prior 10 months ie. new topics this year/months passed.
Thank you
Comments
-
Are you wanting just a simple number or are you wanting to graph this over time?
If you're wanting a simple number:
Topics needed per month:
(MAX(`Goal`) - SUM(`Topics`)) / (12 - MONTH(CURDATE()) + 1) -- +1 to include the current month
Average amount of topics prior 10 months:
CASE WHEN MONTH(CURDATE()) <> 1 THEN -- protect against divide by 0 error for the start of the year SUM(`Topics`) / (MONTH(CURDATE()) - 1) -- Don't include the current month END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Hi @GrantSmith,
Thank you for the answer! I am looking to graph this over time instead of a just a simple number. Any further help with that would be appreciated!
0
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 526 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 440 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive