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!

gradyjofficial
8 - Asteroid

my solution

 

went for a dynamic app for county selection

TonyA
Alteryx Alumni (Retired)

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

hanykowska
11 - Bolide

Not a fan of having years as separate columns,

Spoiler
but it was my first time using reporting tools, pretty cool!
Verakso
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 tableAQI 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 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 resultThe 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

 

 

 

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG
payam2
8 - Asteroid

Thank you for introducing me to the Reporting tools.

dsmdavid
11 - Bolide

App, and I think first time I create a tree

Spoiler
1. Select date & area1. Select date & area2. Main wf2. Main wf3. Output3. Output

Still unable to upload files here, so here's the link:https://github.com/dsmdavid/Alteryx-Weekly-Challenge/blob/master/submitted/sub_Challenge%23104/chall...

DavidThorpe
Alteryx
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 

Flow.PNGMap.PNG
cgoodman3
14 - Magnetar
14 - Magnetar

Need to do a bit learning with the reporting tools.

Spoiler
Challenge 104.PNGh
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
SMSatCFA
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!