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
10 - Fireball
 
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