We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #221: Avocado Consumption

ncrlelia
8 - Asteroid

Challenge 221

TC_bot
8 - Asteroid
Spoiler
TC_bot_0-1611787298064.png

 

RH0258
8 - Asteroid

Lots of crosstabs and transpose tools

Umar
Alteryx
Alteryx

Really enjoyed this one.

 

Here is my solution 

 

 

hbraunius
8 - Asteroid

My solution attached.

aheikes
8 - Asteroid
Spoiler
Challenge221.jpg
apathetichell
12 - Quasar

It took me forever to realize that I could group everything in the Multi-Formula Row... Macro doesn't really help per se - it just made it cleaner. I'm sure there's a cleaner way to use a Batch Macro.

Toons
11 - Bolide

My 2 solutions :

 

Spoiler
Toons_0-1613336064749.png

 

SadiyaGirach
6 - Meteoroid

Completed

NicoleJohnson
14 - Magnetar
14 - Magnetar

Not particularly pretty, I'm sure I would lose at Tool Golf on this one because I'm certain there is a more efficient way, but it works. Also, AVOCADOS ARE LIFE. 🙂

 

Spoiler
WeeklyChallege221.JPG

Cheers!

NJ