alteryx Community

# Weekly Challenge

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.

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

8 - Asteroid

my solution

went for a dynamic app for county selection

Alteryx Alumni (Retired)

Always fun learning a new tool. First time to build tables in Alteryx.

11 - Bolide

Not a fan of having years as separate columns,

Spoiler
but it was my first time using reporting tools, pretty cool!
11 - Bolide

Wow, this was a bit more tricky than I originally thought.

Since the purpose was to make this dynamic and I made this in March, then I choose East Saint Louis from Illinois, Saint Clair County, since i would like to show the most different qualities that I could find in the data.

Spoiler
It was not the dynamic part that was my greatest challenge, that I solved with a formula like this:

`[Month] = DateTimeFormat(DateTimeNow(),"%B")`

The AQI levels was done by providing a table like this
AQI tableThen using the Generate Row tool, to generate an AQI row for each value, and then join it with the filtered data like this
The WorkflowThe hard part was to do the correct coloring and especially the formatting of the Pollutant column, but in the end I did end up with thisThe current resultOh, and the NULL thingie. I started by using the Data Cleansing tool to replace NULLs with 0, but as it turned our, that tool is not very dynamic, so I used the Multi-Field Formula tool instead like this:
`IIF(IsNull([_CurrentField_]),0,[_CurrentField_])`
And that seems to do the trick

Still Climbing
/Thomas

16 - Nebula
Spoiler
8 - Asteroid

Thank you for introducing me to the Reporting tools.

11 - Bolide

App, and I think first time I create a tree

Spoiler
1. Select date & area2. Main wf3. Output

Alteryx

My solution:

Spoiler
Used a download tool to pull the AQI website table definitions down
Built a report to show a record for the current month for all cities

14 - Magnetar

Need to do a bit learning with the reporting tools.

Spoiler
h
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
6 - Meteoroid

Cool!  Enjoyed this challenge...especially because I was the one who published the data from Georgia (correct location format is 1308900002 in the AirNow database if ever you source that site).

Thanks!