We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #94: Have we reached Peak Pumpkin?

ChristineB
Alteryx Alumni (Retired)

A solution to last week's Challenge has been posted here.   I loved seeing the variety of solutions that our Challengers came up with!  Admittedly, my solution probably has more tools than it should but it gets the job done...with only one Join tool!  In the spirit of friendly competition, especially with the self-imposed challenge of "how many Join tools does it take to calculate pumpkin production", I thought I'd give a shout out to our "winner".  Last week, our Challengers' solutions contained an average of 4 Join tool.  Our "winner" with the Fewest Join Tools used: @vishalgupta, with 0 Join tools!  You read that right...ZERO!  There are a few Find/Replace tools in there, though...but I'll take it!  Take the time to check out everyone's solutions; the variety is awesome, and I learned a few new tricks myself! 

 

This week's Challenge will give you the chance to show off your skills with the Predictive Tools to answer one of the most pressing issues of our time: Have we reached Peak Pumpkin?  Is the time of the demand for EVERYTHING PUMPKIN losing steam?  Has Maple Pecan become a force to be reckoned with?

 

For this week's Challenge, we have five input files, one for each branch of a store, with data on pumpkin product sales from 2010 to 2016.  Amalgamate the data into a single data stream to forecast the total expected sales for each product category for the year 2017.  

 

Notes:
- Any Null values should be filled with the average value of that product for that week, across all stores.
- You will need to install the Predictive tools to use the Time Series tools (if you don't have them installed already). 
- Choose the time series model whose Akaike Information Criterion, corrected (abbreviated by AICC) are consistently lower. The data from Store 1 is the best and most complete dataset to use for deciding on a model since it contains no Null values.
- The Predictive District on the Gallery has some tools and samples that you may find helpful for this exercise!

 

Notes for Users on versions 2018.2 and more recent: 

Changes to the version of R used in the Predictive tools have caused ARIMA calculations to yield different results than those in the original post.  Please reference the following instructions and start/solution files:

Any Null values should be filled with the average value of that product for that week, across all stores. 
- You will need to install the Predictive tools to use the Time Series tools (if you don't have them installed already). 
- Perform this challenge using an ETS model to forecast values for the next year.  Leave all settings, aside from those needed to configure the model, to "Auto". 

- Expect your output to contain negative values

- Refer to the start file "challenge_94_2018_2_start_file.yxmd" and solution file "challenge_94_2018_2_solution.yxmd" that I posted to my reply to another Community user on page 3 of this Challenge's post. 

 

 

 

    

LordNeilLord
15 - Aurora

Hey @ChristineB,

 

Is this the correct start file? It looks the same as last weeks :)

ChristineB
Alteryx Alumni (Retired)

@LordNeilLord It's only lunch and I've already reached Peak Monday!  The Start File has been updated.  Thank you for setting me straight!

patrick_digan
17 - Castor
17 - Castor
Spoiler
2 for the price of 1! I thought there was an error with the factory tools, so I created a quick batch with the normal TS tools. Turns out it was just user error :) 

I used the directory tool and the 2 dynamic inputs to get all the data aggregated. I transposed it and just sent store 01 through the ARIMA and ETS to see that ARIMA had a lower AICC. Then I filtered the data for nulls and got the average to fill the holes. I summarized the data at the week and product level before running it through the time series tools (my quick batch process vs the factory tools).
Capture.PNG
LordNeilLord
15 - Aurora

I spent ages trying to get the answer just using the standard time series prediction tools but I couldn't get the right result....so I switched to using the Predictive District tools and STILL couldn't get the correct result. After much swearing I finally realised that I had only imported 4 out of 5 excel files! Lesson learnt...make sure you import all of the data first!

 

Spoiler
Weekly Challenge 94.png

 

Kenda
15 - Aurora
15 - Aurora
Spoiler
I created a macro to loop through each of the different products and get their forecasts.

challenge 94.PNG
NicoleJohnson
15 - Aurora
15 - Aurora

My solution!

 

Spoiler
Very similar to @Kenda - went the Batch Macro route as well. Also, I clearly need more forecasting practice in my life. :)

WeeklyChallenge94.JPG

NJ

paul_houghton
11 - Bolide

This is my first version. Everything matches except for the produce. Not sure why yet

 

Spoiler
Challenge 94 test run.jpg
paul_houghton
11 - Bolide

Doesnt look like the solution has been packaged right. Lots of broken macros.

ChristineB
Alteryx Alumni (Retired)

@paul_houghton, it's packaged now!  That should be better!