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
It would be interesting to see an update on these stats to see how actual to date compares with the prediction
Spoiler
Process:
- Filter out pre-2017 data so it is not included in the forecast model
- Create date field (not sure if this is needed)
- Calculate running total of posts
- ARIMA model on F3 (keep defaults)
- TS forecast on model results
- Union of pre-2017, Running Total, and predicted data
- Combine post data into single field
- Calculate running total
- Filter out data where running total <1m
- Select first record
- Recreate date
- Clean-up
- Filter out pre-2017 data so it is not included in the forecast model
- Create date field (not sure if this is needed)
- Calculate running total of posts
- ARIMA model on F3 (keep defaults)
- TS forecast on model results
- Union of pre-2017, Running Total, and predicted data
- Combine post data into single field
- Calculate running total
- Filter out data where running total <1m
- Select first record
- Recreate date
- Clean-up
Spoiler
At first I did a running sum before the time series model, and that gave me an answer several years later than found here.
My Effort
Spoiler
Why didn't I know about the running total tool before now?
I get that it is over 1m on 1st July 2023, so the millionth post is in June 2023
I get that it is over 1m on 1st July 2023, so the millionth post is in June 2023
