Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI 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!
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....