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

[Vinutha]

Can possibly be done in fewer steps

[dsmdavid]

Can finally attach files, although cannot edit my previous reply

[mbogusz]

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

[sgrabish1]

Thanks for practice exercise!

[MFish]

For San Diego

[apabonok]

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]

Spoiler

[AmeliaG]

Spoiler

[SueDonim]

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

[danicahui]

Spoiler