Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #3: Running Averages

Spurs
8 - Asteroid
Spoiler
Spurs_0-1671816103694.png

 Not entirely sure if my output is the same, some of my figures look a little different but not sure if this is just down to rounding. 

 

flavio-matos
7 - Meteor

My solution

Spoiler
flaviomatos_0-1672308257387.png

 

Minsu
7 - Meteor

Here is my solution!

kristiadiuisan
8 - Asteroid
Spoiler
Spoiler
Alteryx_challenge_3_KU.png

 

isabelcc
8 - Asteroid
Spoiler
3.png

My Solution

alacoume
9 - Comet

My (brute force) solution...

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Gave my interpretation of the solution.

 

Note: If the required amount of previous months weren't available to calculate the specified running avg, I assigned the result as null; i.e. if you are in Feb, and only January is available as a prior month, we shouldn't be able to do (Jan+Feb/)2 as that's a 2-month running avg, so I'd assign Feb as a null. Correct me if this assumption is wrong! 🤓

Spoiler
BS_THE_ANALYST_0-1673712399400.png

 

All the best,
BS

LinkedIN

Bulien
Sharod100
7 - Meteor

Hello,

 

Here is my solution to Challenge 3! :) 

Blue1
7 - Meteor

Thank you for the challenge - my solution is attached.

patrickprentice
8 - Asteroid

Hard one for me but I just recently had to do some running numbers at work.  Solution: