Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #132: When Will Community Hit 1,000,000 Posts?

Sashikumar
8 - Asteroid

My solution.

Spoiler
ch132.PNG
helpfultoaster
Alteryx
Alteryx

Do we know if our predictions have been proven wrong yet?

soroosj
8 - Asteroid
Spoiler
First predictive tools workflow!!Capture.PNG
cchandler21
Alteryx Alumni (Retired)

Solution attached

Thableaus
17 - Castor
17 - Castor

Here it goes my solution

 

Spoiler
Thableaus_0-1622922123491.png


Prepped the data to use only data >= 2017. Set up the months, built the plot to check if everything was right.
Set up the ARIMA model and used the TS Forecast tool (did it for 96 months cause the targeting number was pretty high). Although if you check the plots you see that the model basically loses efficiency after 2020/2021, and it becomes linear.
Used the Upper boundary of the confidence interval (high). Unioned the forecasted values with the actual values and just did a running total. 

Good way to exercise the time series tools, loved it. Cheers,

Joe_McCoy
8 - Asteroid

Thanks for the test of some tools I have not used before.

Spoiler
Joe_McCoy_3-1624994392873.png

 


 

 

 

 

cwkoops
8 - Asteroid

Tool count/efficiency not a strength with this one

KilianL
Alteryx Alumni (Retired)

Interestingly, the forecast changes to 2026 if we forecast the total number of posts instead of the monthly posts.

 

On the community homepage, it says we are at 346.000 posts. This is closer to the 'total number' forecast, which predicted this number for March this year.

 

Spoiler
132 - When Will Community Hit 1,000,000 Posts - Kilian.png
JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission.

MichelleL
Alteryx
Alteryx

Good Time Series practice, thank you!