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

Highlighted
Alteryx
Alteryx

A solution to last week’s challenge can be found here.Source: https://en.wikipedia.org/wiki/Pok%C3%A9monSource: https://en.wikipedia.org/wiki/Pok%C3%A9mon

 

With over 800 Pokemon in existence, avid Pokemon fans could use some help figuring out what Pokemon are available for their them to use on their teams. Build an Alteryx App that helps sort through the options.

 

Configure the App's interface tools to use a List Box for the Regions, a Dropdown tool for the type, a Check Box tool that allows legendary Pokemon, and a Check Box tool that removes regional variants of the same Pokemon.

 

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! 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

App attached.

 

Can somebody explain when you should use the thunderbolt and when to use the Q anchor?

 

Spoiler

AppApp

 

Highlighted
Alteryx Certified Partner

User Interface:

Spoiler
2int.PNG

Workflow:

Spoiler
1.PNG
Highlighted
Alteryx Partner

Cool challenge. I don't make a ton of apps, so these are always good practice.

 

Spoiler
Capture.PNG

Watch my solution video here:

Spoiler

 

Highlighted
Alteryx Certified Partner

Fun to make an app on Monday Morning! 

 

 

Spoiler
Blake_0-1589205713992.png


Blake_1-1589205756543.png

 

Highlighted
14 - Magnetar
14 - Magnetar

My solution!

Spoiler
WeeklyChallenge215.JPG

NicoleJohnson_0-1589205919973.png
NicoleJohnson_1-1589205973492.png

Cheers!

NJ

Highlighted
16 - Nebula
16 - Nebula
Spoiler

1) I like using reference shortcuts in my filter as it makes it easier to test/debug. I just use Control  + R to run it like normal and can change test values on the Workflow tab.
2) Sorry for tooting my own horn, but I have some ideas that would make working with interface tools better/easier
a) Data from Connected Tool option - why should I have to crosstab my data? Adding "data from connected Tool" to the dropdown/listbox could allow you to go straight from the summarize tool to the interface tools.
b) 2 small changes - Why can't I change the name of the question in the workflow tab and change my test value in the tool itself? 
c) Let Question constants be used like other constants - Why can't I just reference my questions like [Question.Region]? It works for User Constants, so I think it would be great if they added if for Question Constants. The one drawback of using reference shortcuts is that you have to know the syntax, so letting questions behave like normal fields would remove that.


patrick_digan_0-1589205411635.png

 

Alteryx Partner
Spoiler
dsmdavid_0-1589207442769.png

 

Highlighted
Alteryx Certified Partner

I just love the interface tools!!! Cool challenge

 

Spoiler

Victor_Mendes_0-1589211095180.png

 


 

Highlighted
Alteryx Certified Partner

When you use the "Q" anchor, you can reference the connection inside your tool the one with the "Q" connection.

And when you use the thunderbolt you create your Fórmula inside the Action tool

Fórmula tool with "Q" Anchor

Victor_Mendes_0-1589210860781.png


Formula tool with Thunderbolt, the [#1] doesn't exists

Victor_Mendes_1-1589210890331.png

Victor_Mendes_2-1589210919072.png