This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

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.

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?

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.

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.

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.

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

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.

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.