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

[ChristineB]

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 (O₃),  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? 

 

[patrick_digan]

Spoiler

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. 

[jamielaird]

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

[Natasha]

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

[shanakag]

---

[CHarrison]

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

[kat]

Here's my attempt :)

Spoiler

[PhilipMannering]

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

[ggruccio]

Cleveland's air quality is healthier than I thought!

[data_rachel]

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.