community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #115: Let's get crafty!

Sr. Instructional Designer
Sr. Instructional Designer

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

 

 

 

 

 

 

 

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
Quasar
Spoiler
Challenge #115 app.PNG
Challenge #115 workflow.PNG
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
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

 

 

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.
Bolide
Bolide

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.
Alteryx Partner

My solution

Spoiler


2018-05-08_12h50_31.png

Sr. Instructional Designer
Sr. Instructional Designer

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

Asteroid