Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

Vinutha
8 - Asteroid

Can possibly be done in fewer steps

dsmdavid
11 - Bolide

Can finally attach files, although cannot edit my previous reply

mbogusz
9 - Comet

Chose Denver and used October/10.  Looks like it's got some healthy air quality over there.

 

@Verakso thanks for the From-To / Start-End AQI range groupings table in your solution, which I used as Input Data and then was able to generate rows from the called out ranges.

Spoiler
2019-10-31 08_17_00-Greenshot.png
sgrabish1
8 - Asteroid

Thanks for practice exercise!

MFish
8 - Asteroid

For San Diego

apabonok
8 - Asteroid

HI! Very nice challenge! This is my solution.

 

I have filter by the same month and city in order to compare the result.

In order to run dinamically, just change filter sentence as I show in the workflow. 

My table format is not completly equal but data are Ok. 

apabonok
8 - Asteroid
Spoiler
Captura de pantalla (4).png
AmeliaG
Alteryx
Alteryx
Spoiler
104_screenshot_1.png104_screenshot_2.png
SueDonim
8 - Asteroid

Good exercise for table formatting - haven't done that - interesting

 

Spoiler
Process:
- Filtered data for Denver (mainly so I could compare results)
- Calculated Month, Year, and CurrentMonth fields
- Filtered by CurrentMonth
- Catgegorised AQI for each of the 3 types provided, NO2, SO2, and O3
- Transposed data to get all color result categories in a column
- Created Pollutant field by extracting from Name
- Grouped by Year, Month, Pollutant, and Value and counted Value (number of days in that month of different categories)
- Cross-tab data back into columns by year
- Converted color to category (based on the AQI descriptions
- Created table with autoformat of rows based on category

MySolution.PNG
danicahui
8 - Asteroid
Spoiler
Challenge 104 2019-12-04.jpg