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

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.

challenge_104_start_file.yxzp

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

challenge_104_JL.yxzp

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

challenge_104_Natasha.yxzp

shanakag

pic 1.PNG pic 2.PNG

challenge_104_start_file.yxmd

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

Challenge #104.yxzp

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

challenge_104 - Dynamic Air Quality Report.yxzp

ggruccio

Cleveland's air quality is healthier than I thought!

challenge_104_gg_finish.yxzp

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.

challenge_104_start_fileRP.yxzp

LordNeilLord

@data_rachel, are you going to be in the 100 club soon?

adamp

I'm just joining the community and jumping in for the first time on the weekly challenge. This was a good piece of exercise. Thanks

challenge_104_work_file.yxzp

LordNeilLord

Welcome to the community @adamp!

Have fun with the weekly challenges, they are a great way to learn Alteryx

kcgreen

This is my 30th :-)

I've used the Table tool several times but never thought to add conditional formatting.

Spoiler

challenge_104_ReportingColors.yxmd

bdaniels

First Challenge, went local;

Spoiler

Canvas

Costa Mesa Results

Good practice!

challenge_104_start_file.yxmd

data_rachel

Here it is as an analytic app. Took a bit longer than I had expected to remember how they work!

challenge_104_start_fileRP.yxzp

Ilías

I chose Philly!

Challenge 104 ili.yxmd

JosephSerpis

Challenge Completed

Challenge_104_Joe_Serpis.yxmd

NicoleJohnson

Fun challenge! I chose to make it a little more dynamic by building a tree that can be used to choose your city (I attached the workflow I used to build the tree as well). Noticed after testing for a few different cities that I needed to group by Site # since there are some cities that contained more than one Site (which was creating unusually high AQI values for the month by summarizing them together across sites). So I split out the output report into a separate grid per Site (based on city selected in the tree). Used Phoenix, Arizona as my sample city selection, largely because it's been 20 degrees here this week, so you know, wishful thinking. Plus the air quality looks pretty good!

Spoiler

Cheers,

challenge_104_TreeGenerator.yxmd

challenge_104_NicoleJohnson.yxzp

Elena_Caric

Ended up being quite long. Couldn't get the first column of the table to be all white though. Went with a simple app to choose a city.

Spoiler

challenge_104_start_file.yxmd

Ayelavan

This is my solution,

I used the datetimenow() to determine the current month and filtered the [Date Local] field by that value. Also used converted the workflow to an analytic app to allow users to select the city they want the results for.

challenge_104_Completed.yxzp

DriveMyData

Week 104.yxmd

DriveMyData

I got some different numbers for denver...

Week 104.PNG Week 104 Output.PNG

Week 104.yxmd

tochy

challenge_104_solution_tochy.yxmd

unknown

challenge_104_Ryan_Lambert.yxzp

estherb47

Started along the same path as @patrick_digan, grabbing the table from the EPA website. But ultimately decided to copy the results into a text table. Used a dynamic replace tool instead of a nested IF to assign the category. Transpose, summarize, crosstab, and report!

Created an app that allows the user to choose which city they'd like to see, and outputs the result. Tried the tree tool for the first time. Creating the table was a great exercise with using the Tile tool.

I'd love to make this dynamic and have the data pulled directly from the web, for the most current data. Any suggestions @ChristineB?

challenge_104_EHB_solution.yxzp

LordNeilLord

I decided that it wasn't for me to determine which city to choose, so I made it into an app

Spoiler

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

challenge_104_LNL.yxzp

MMehdi

Challenge #104 resolved as an Analytic app with PDF reporting

Spoiler

Report

Wizard

Workflow

challenge_104_start_file.yxwz

StevenBetts

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

challenge_104_start_file_SMB.yxmd

SeanAdams

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.