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

Christoph_Ebersbach
アステロイド

Challenging but great. Learned a lot in this challenge!
Output file of soulution is heavily lagging/freezing the total app for a long time unfortunately.

Hopefully my naming of columns is ok...

Nicholas_Bignell
アステロイド

Completed

kaianderson
アステロイド

Definitely agree with the previous comments about errors in the provided output file, but here's the main process.

T_Willins
14 - Magnetar
14 - Magnetar

Reposting to add spoiler (to get challenge tracker to work correctly).  NOTE:  This is old solution prior to changes mentioned in challenge thread start.

 

スポイラ
Workflow 3.JPG

 

CR_Marland
アステロイド
 
mtedw
メテオール

Solved!

Kong
アステロイド

Keep going challenges.  Challenge #3 completed.

ChrissD
メテオール

This made my alteryx crash, as I don't have the latest version. Is it necessary to use the latest file version for this challenge? 

vicki_garlick
メテオール

Found this one quite hard and the final output doesn't quite match, but believe this is what you've asked for. Think other people have made similar comments about final output not seeming quite right in the solution.

Xlblaze
メテオール
スポイラ
Xlblaze_0-1572514750979.png

My Solution

Its not elegant but it works.
Alteryx also didn't like the text input with the results and would crash each time I clicked it. (may be because we are using an outdated version)