In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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

TarunDeep
8 - Asteroid

Solution:

Spoiler
Not sure about the correct number of results as I got 32832 records in my output. Used row formula tool to get 3 months and 6 months average.

Reading a few posts, I got to know that there were some null values in the dataset. I created a 0 value for each category and value typr for each year month. Will that handle the situation here? Need some suggestions.

justindavis
10 - Fireball

I think this is the most unclear weekly challenge of the lot. And my solution is probably my most unsophisticated to match.

mccartycp
7 - Meteor
Spoiler
 

This was an interesting challenge. The solution seemed messy to me. 

rmassambane
11 - Bolide
 
AV8
8 - Asteroid

Solution is bit different but overall good exercise.

Spoiler
Spoiler:3_Workflow.JPG
jvn0005
6 - Meteoroid

Although I don't think the original solution is 100% accurate, this exercise was interesting. I'm curious if anyone got the same variances on some of the records from the original solution as I did.

Ronald_Do
7 - Meteor
Spoiler
Ronald_Do_0-1577817002625.png

Yay to solutions! Took me awhile but I think I got it!

jdbartosh
8 - Asteroid

I have downloaded the starter file multiple times. Each time I attempt to look at text output data Alteryx freezes on me. Is this just me?challenge_3.PNG

jdbartosh
8 - Asteroid
 
BrandonB
Alteryx
Alteryx

Solution attached