Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

geoff_zath
Alteryx
Alteryx
Spoiler
geoff_zath_0-1661194130658.png

 

Thomas_Wells_2dot0
8 - Asteroid

Attached! 

 

An odd challenge, missing context, but oh well! Glad to have this one finished. 

 

Spoiler
solution.jpg
atripp
6 - Meteoroid

attached

lifranca
8 - Asteroid

My output was a little different, I kept the RM Category as a column instead of using the RecordID.

I complicated a little bit, but I think I got there.. lol

ZacharyRyanTIL
8 - Asteroid

solved

GabrielaTudor
8 - Asteroid

It was a real challenge, as I have never used the multi-field formula to calculate a running average and I had learnt a lot.

However, I think the output required was not clear and it had a wrong format, so I have changed the output in my final solution. Here is a preview of how I think it should have looked like:

Spoiler
GabrielaTudor_0-1662036952809.png

 

grazitti_sapna
17 - Castor

grazitti_sapna_0-1662092376243.png

 

Sapna Gupta
WillH
7 - Meteor

My Solution but the given expected output is very jank

mg46
8 - Asteroid
Spoiler
mguarniere_1-1662757399661.png

 

This one took a little creative renaming so I could keep track of the type of average.  The original output was a little tough to digest.  But it was great practice. :)

destroyboot
8 - Asteroid

Hi,

 

Here is my solution :)