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 :)