Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
nice challenge, here is my solution:
I have used a dynamic formula so it will always bring in the results for the month when the Workflow was run. It creates a boolean result I can filter off the False
my results:
note I have also used a multi-row formula to make the lines underneath the same Pollutant "empty". same style as the Challenge's Output
nice one!
Here is my solution:
Here is my submission, set the filter month = the current month.
It appears that september is a more dangerous month to be in Denver thant February. The first uphalf of the workflow is to check my results with the answer. The second one is as it was suggested, getting data from the current month.
It should be possible to develop a app to filter the city. Maybe on the next one.
This took me a lot longer than I was expecting. Getting the data was reasonably quick for me but the challenges for me were in the table output as I'd not used it before. Took me a while before I figured out how to 'blank out' the text so that the category appears pivoted. The other was using drop down for month and changing to an App which I struggled to get to work. But now I've learned two more tools so that's great. Good fun.