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 #94: Have we reached Peak Pumpkin?

Watermark
12 - Quasar
12 - Quasar
Révélation
MT Solution 94.png

Watermark
12 - Quasar
12 - Quasar
Révélation
oops  duplicate wrong challenge ignore

duartepimentel
Astéroïde

Nice one. Solution Attached :)

TonyAndriani
Comète

Reposting under my new user ID.

binuacs
Arcturus

solution attached

mmontgomery
Bolide

Challenge #94

scoles0617
Astéroïde

My solution:

mouna_belaid
Astéroïde

Please find below my solution.

 

 

harrame
8 - Asteroid
8 - Asteroid

Don't know if it's been mentioned yet but I found some issues with the 2018.2+ solution. The input macro brought in the Store01 file five times because the action tools in the input_macro need to be updated accordingly: 

harrame_1-1657203604507.png

 

Révélation
Additionally, I wonder if it might be better to replace nulls with the average from the other stores in the same year and week instead of using the average from the other stores across all years? 

In solution:
harrame_3-1657206234125.png

 

Proposed (which I did):
harrame_2-1657206222753.png

 

Anyways, here's my solution, featuring a batch macro that performs the ETS forecasting for each product
harrame_4-1657206336001.png

 

And here's a snippet of the results I got:
harrame_5-1657207604111.png

 

Reesetrain2
Comète

All,

 

My submission:

 

Révélation
Capture.PNG