Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Wallarion
6 - Meteoroid

I was confused by two things - not fully intuitive output format, but beauty is in the eye of the beholder and third "running 3m average" of the example (why 233?), but later saw 230 in the Output.
As a result - twin Browse tool -) and different order of Name column values that easily tuned by ordering in the Join Multiple tool.

Spoiler
challenge_3_screenshot.JPG

Kale_Malcom
8 - Asteroid
Spoiler
Kale_Malcom_0-1572996985340.png

There's probably a better way to do this than my solution as mine feels static.  If a user later needs 9 or 12 months rolling you'd be back here adding or adjusting formulas...

Elysia1
7 - Meteor
 
JamesCameron
8 - Asteroid

My effort. Certainly added to my knowledge of the Multi-Row Formula tool

 

Spoiler
JamesCameron_0-1573142031614.png
jackdaniels
8 - Asteroid
Spoiler
Capture.PNG
Komal_
6 - Meteoroid

Solution 3 done 😛

erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

DavidLane
8 - Asteroid
 
SeanAdams
17 - Castor
17 - Castor

Resubmitting based on revised challenge files

 

 

OliverJ
7 - Meteor