Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANot a fan of having years as separate columns,
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.
[Month] = DateTimeFormat(DateTimeNow(),"%B")
IIF(IsNull([_CurrentField_]),0,[_CurrentField_])And that seems to do the trick
Still Climbing
/Thomas
App, and I think first time I create a tree
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...
My solution:
Need to do a bit learning with the reporting tools.