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 #280: Weather Permitting

lzhang21
Alteryx Alumni (Retired)
Spoiler
challenge280.PNG

Awesome challenge. Throwing out the null values results in one less day for biking. 

alexnajm
16 - Nebula
16 - Nebula

Great job Marie, being very sustainable!

Spoiler
challenge_280_start_file_Alex Abi-Najm.PNG
Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1628692308093.png

 

Kaitlin-Sheehan
Alteryx
Alteryx

Fun challenge! 

ggruccio
ACE Emeritus
ACE Emeritus

I had the answer at summarize tool, but added extra tools to format like the solution.

 

Spoiler
 

ggruccio_0-1628706988873.png

 

jsanche5
5 - Atom
Spoiler
wow.png
Spoiler
 

My first time sharing my results. Learned how to get a weekday out of a date. Could it be shorter, yes, next time. 

AndrewPowell
8 - Asteroid
Spoiler
AndrewPowell_0-1628717016322.png

So I went with select and filters to reduce the data set quickly, a formula to calculate the method and then a cross tab to sum and count the data

Akela3
5 - Atom

Done

JoseV
7 - Meteor

Ditch the car!

 

Spoiler
JoseV_0-1628721734153.png

 

apathetichell
18 - Pollux

This was part of my series in trying to get my seven year old to learn Alteryx. I was proud when he dragged a formula tool onto the canvas... the multi-field formula was me though.