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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #104: Love's not the only thing in the air!

Alteryx Certified Partner

Challenge #104 resolved as an Analytic app with PDF reporting

Spoiler
Report.pngReportWizard.pngWizardWorkflow.pngWorkflow
Asteroid

I chose Baton Rouge as I'm off on holiday to New Orleans shortly and it's the closest place I could in the data set that I could find/think of!

Enjoyed this one - my first play with the reporting tools.

 

Spoiler
I managed to keep the results relevant to the current month by using a filter on if the datetimemonth was equal to today's datetimemonth

Challenge 104.jpg
Aurora
Aurora
Great excuse to practice analytical apps and conditional formatting. I must admit - I struggled with the grouping behaviour and learned quite a bit about the reporting tools.
Quasar

Solution attached

Alteryx Partner

My solution:

Spoiler
challenge 104.jpg
Aurora

Always fun to play with new tools.  Finagling the data and the table options to reproduce the required output was a learning experience

 

Denver in August

 

Table.png

 

 

 

Spoiler
Solution 104.png

Dan

 

Asteroid

My solution to challenge #104 is attached.

 

Denver AQI Levels - February.PNG

 

Asteroid

Solution attached

Pulsar

This one had me scratch my head a bit. Good practice with the Table tool in the end!

Asteroid
Spoiler
104.JPG

Used a list box populated with states and counties to make the app a little more dynamic, will probably increase this to allow user to select year when i get an opportunity to build further.