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!

LiuZhang
Cometa
Spoiler
104.png
Chantelb
Cometa
Spoiler
Chantelb_0-1635310158336.png

 

jacekDziuba
Meteoro

Great challenge to exercise reporting - thank you ! 🙂

ARussell34
Asteroide

I asked my coworker to pick a state and they also picked Colorado so I ran with it. I also wanted to include all levels of AQI for the output as well as the location and site number to the output. I also was able to make the table dynamic for months, but I might have to return to see if I can update and make it dynamic by location and site too!

jjrbondoc
Asteroide
Spoiler
jjrbondoc_0-1637094477704.png

 

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 104.png

juliabarale002
Asteroide

💘

ainderike
Asteroide

I came here to practice the reporting tools, but ended up building an app with a simple macro 🙂

Nevertheless, I've learned a lot doing this one. I have a challenge with the table tool, as it was not dynamic and rearranged my years depending on city selection. This article was helpful: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Basic-Table-Tool-Changing-the-order-of....

Spoiler
ainderike_0-1639655275396.png

 

r_manju02
Asteroide

Here is my solution

derekbelyea
Cuásar

derekbelyea_0-1641258795981.png

 

 

derekbelyea_1-1641258870885.png