Weekly Challenge

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

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

Submit Feedback
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.

Challenge #222: Where There's a Whale There's a Way

Highlighted
Alteryx Certified Partner

I am reposting my solution as the leaderboard might be missing this post from my account

 

Spoiler
Spoiler
222.jpg
Highlighted
7 - Meteor

A nice and simple challenge. This was a fun one.

Highlighted
8 - Asteroid

Fun challenge on whales.

Highlighted
8 - Asteroid

I had to add some additional sorts to get it to look like the output!

Highlighted
7 - Meteor

This is my solution

 

Spoiler
luispe24_0-1595352536897.png

 

Highlighted
Alteryx
Alteryx

Nice easy Data Analysis example. Thanks to @ArtApa, for mentioning this example for AMP engine comparison. 6.4 seconds down to 3.4 seconds by using AMP engine.

 

Spoiler
Use of Count Distinct in Summarise to reduce tools
I joined the small tables first, to reduce sorting speeds on the joins

KaneG_0-1595383135127.png

 

Highlighted
7 - Meteor

Quick and easy!

 

 

Spoiler
dlopez13_0-1595627442488.png

 

 

 

 

Highlighted
7 - Meteor

Good fun! Enjoyed this one...

Spoiler
challenge_222_spolier_WY.PNG
Highlighted
6 - Meteoroid

If at first you don't succeed whale whale again.  

Highlighted
8 - Asteroid

Here's my solution

 

Spoiler
Carlithian_1-1595860357449.png