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

jenniferk
7 - Meteor

The posted solution as of 9/20/19 seems to be modified from the original dataset and references fields that are now missing, which throws off the dynamic rename module so the final output column names are unclear.

 

Attaching my solution from the new dataset:

Spoiler
soln3.PNG

 

KT2
7 - Meteor
Spoiler
SPOILER

Boom.

Stevej028
7 - Meteor
Spoiler
image.png
RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_3_RODO_Solution.png

I didn't really like this challenge

ZenonH
8 - Asteroid

Careful not to click the text input tool for the solution, it will freeze Alteryx for a while!

Spoiler
ZHSOL.png
myouree
8 - Asteroid
 
Nicole_L
8 - Asteroid

That was very challenging.  I hope I did this right.

Peter-H
6 - Meteoroid
 
kmcdaniel
8 - Asteroid
Spoiler
challenge3_screenshot.png
SueDonim
8 - Asteroid

I'll admit to getting a hint on how to simplify this one, but then was able to complete on my own.  Very clever way to simplify.

 

Very useful exercise to see how to use tools to simplify processes

 

Spoiler
The transpose and cross-tab made this much easier than having a dozen multi-row tools.

Process
- Add Record IDs to allow for transpose and cross-tab
- Transpose on Record ID, HP category, Year, and Month
- Use two Multi-Row tools (one for 3mo average, the other for 6mo average)
  -- Had "Values for Rows that Don't Exist" set to values of closest valid row to enable it to deal with initial months and nulls
- 3 cross-tabs to move back to original orientation
  -- Original data
  -- 3mo
  -- 6mo
- Dynamic Renames to add "r3mo_" or "r6mo_" to start of field name
- Join Multiple to bring it all together

MySolution.PNG