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 #115: Let's get crafty!

Highlighted
Alteryx
Alteryx

A solution for last week's challenge has been posted here in both video and workflow forms! 

 

This week's Challenge lets you get crafty!  Create an app to allow a user to search a list of craft canned beers by state of origin or beer style.  Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles.  Feel free to customize the app as you see fit! 

cropped_image.png

 

 

 

 

 

 

 

Highlighted
16 - Nebula
16 - Nebula
Spoiler
You may have to run this as a workflow first to populate the drop downs. I love using the %Question.Name% syntax to pass variables. I used the dynamic rename because the crosstab goofs up fieldnames (changes spaced and special characters to underscore). If I'm allowed to toot my own horn, this challenge would have been easier if this idea or this idea were completed 🙂

Capture.PNG

Capture2.PNG
Highlighted
12 - Quasar
Spoiler
Challenge #115 app.PNG
Challenge #115 workflow.PNG
Highlighted
8 - Asteroid

Here's my submission!

 

Spoiler
I would have prefered to have my Beer Style drop-down get it's values from the dataset, instead of hardcoding the list...
I'll be looking at other's submissions to see if there was a graceful way to do this.
workflow.JPG
Highlighted
Alteryx Certified Partner

Here's my solution:

 

Spoiler
A little searching led me to the Collapse Group When Deselected trick, which I hadn't come across before, and will definitely be using again..solution_115.png

 

 

Highlighted
11 - Bolide
Spoiler
'Cheated' by using the output of a browse tool to populate the dropdown list, but until the dropdown can be populated dynamically, it takes the same steps as the other option of rerunning the app in alteryx if the style list should ever change.
Highlighted
12 - Quasar
12 - Quasar

Got crafty, and a little thirsty as well...oh well at least I have my water bottle right here!

 

Spoiler
Created an app using the detour tool.

Seemed as though the filter by "WY" in the example output was somehow showing multiple styles for each beer name.  It had 66 rows.  I pull 15 when I run the app.
Highlighted
Alteryx Partner

My solution

Spoiler


2018-05-08_12h50_31.png

Highlighted
Alteryx
Alteryx

@ggruccio good catch!  I updated the start file to reflect the correct results.  

Highlighted
8 - Asteroid