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.
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

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 #215: Gotta Catch 'em All!

SeanAdams
17 - Castor
17 - Castor
Spoiler

Solution 1.pngSolution 2.png

AkimasaKajitani
14 - Magnetar

My solution.

 

I'd like to put the parameters into the text input tool once rather than overwriting the values of each tools directly. Because it's easier to debug.

 

Spoiler
AkimasaKajitani_0-1604673324809.png

 

Ross_Easton
7 - Meteor

Solved

 

Spoiler
215.PNG

Paradox
7 - Meteor
Spoiler
Paradox_0-1605289798458.png

Pivoted the valid options into the interface and used the selections to filter the results:
Contains([#1],[Region]+"=True")
And ([Primary Type] = [#2] Or [Secondary Type] = [#2])
And Switch([#3]="True",1,0,IsNull([Legendary?]))
And Switch([#4]="True",1,1,IsNull([Regional?]))

stephM
8 - Asteroid

Great challenge to learn more about apps! Solution attached and screenshot below.

 

 

Spoiler

Answer: 22

 

 

 stephM_1-1605540308968.png

stephM_0-1605540263111.png

michael_leoni
8 - Asteroid

Please see my solution below.

Angela_M_Burks
Alteryx
Alteryx

Solution attached.

hannahc
8 - Asteroid

My solution is attached! Good practice with the app interface tools.

 

Spoiler
I got 22 re: Once configured let us know how many Ghost Type Pokemon are in the Alola, Galar, Johto and Kanto regions with Legendary and Regional variants allowed! 

 

RH0258
8 - Asteroid

I feel really old now having grew up with pokemon and now not knowing even a third of these! Decided to add an extra option to allow the user to decide if they wanted to search the secondary type or not.

 

Looking at the solution, I should really remember to use the IN command next time I use a list box. Makes it easier.

BeginnerMindset
8 - Asteroid
Spoiler
BeginnerMindset_0-1613324534875.png

 

Spoiler
BeginnerMindset_1-1613324778543.png