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