cancel
Showing results for 
Search instead for 
Did you mean: 
FRIDAY Deadline | Submit your Alteryx Use Case by August 17th to qualify for this round of Analytics Excellence Awards presented at Inspire Europe 2018! Learn more.
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 #104: Love's not the only thing in the air!

Instructional Designer
Instructional Designer

A solution to last week's Challenge can be found here!

 

Love...it's not the only thing in the air this week!  The Environmental Protection Agency (EPA) measures the concentrations of certain pollutants, like ozone (O3),  and assigns an Air Quality Index (AQI) value to that concentration.  For each pollutant with measurements, calculate the number of days in the month of February assigned as each category on the EPA's Air Quality Index. 

 

For this Challenge, I chose to work with data recorded in Denver, CO.  The dataset provided includes cities from all over the US; feel free to "choose your own adventure" and select a city that interests you!  Design the workflow to be as dynamic as possible; imagine that someone will run this workflow every month.  What can you do to make sure that the results reflect the month in which the workflow is run? 
 
Magnetar
Magnetar
Spoiler
Capture.PNG

I used the download tool to pull the AQI buckets from the EPA directly. I used the dynamic replace to convert the numbers to their corresponding AQI. I used My multi row multi-field macro to blank out the city, state and pollutant from being repeated. 
Alteryx Certified Partner

Here's my solution. I decided to filter the data to only show the most recent year available for the selected site, and scaffolded the data to include zero rows. Colours are replicated from the AQI website. With a bit more time I'd make this into an analytic app but I'm happy with this for now.

 

Spoiler
Screen Shot 2018-02-12 at 20.32.57.pngScreen Shot 2018-02-12 at 20.27.41.png

 

Alteryx Certified Partner

Since Inspire 2018 is going to be in Anaheim, CA I chose the closest station located in Orange County. It was a good suggestion to make sure that the latest month is included, as the last measurements in Costa Mesa were done at the end of 2015! I didn't make an app to dynamically select the location but included the last date of measurements and played a little bit with a layout. 

 

Edit: Here is an updated workflow & screenshots, as I didn't notice that results need to be filtered for a run month. I really need to start reading the task more carefully..

 

Spoiler
Screen Shot 2018-02-12 at 23.04.56.pngScreen Shot 2018-02-12 at 23.04.35.png

 

 

 

Meteoroid

pic 1.PNGpic 2.PNG


Asteroid

As a hardcore Breaking Bad fan, I decided to choose Albuquerque! As previously mentioned, it would be nice to make an app of this letting the user decide which city/state they want to include 

 

Spoiler
104.png
Asteroid

Here's my attempt :)

 

Spoiler
Challenge #104.PNG
Alteryx Certified Partner

And my attempt. Thank you @Natasha for showing me the Table formatting apply to rows. I was gonna spend all day applying the rules to each column before hand.

 

Spoiler
challenge_104 - Snip.PNG
Bolide
Bolide

Cleveland's air quality is healthier than I thought!

Alteryx Certified Partner
Spoiler
A fun introduction to the reporting tool. Like everyone else, I would like to make this into an app where users can choose their city. I went with Kansas City for no particular reason, although I did test San Diego and there seemed to be no data for Feb for any year for San Diego. I also tested Denver but my results did not match the example. I feel like I could have made this a bit simpler. I might have taken a few shortcuts and it may be a little quick and dirty so I hope to spend some time over this weekend trying to re-jig this. Keep an eye out for an update.
UPDATE1: Looks like there was a problem with my previous submission. Fixed it and updated now.

challenge104.PNG