ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
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
It was quite easy to do without macro but have to admit that was diffcult for me to implemnet a batch macro. It is great that you forced me to go out from my comfort zone.
スポイラ
Macro:
and workflow without macro:
The biggest challenge was figuring out whether the Open column was referring to the act of opening an account or whether the account was still open.
I misunderstood the explanation initially as the denominator referencing the act of opening. When in fact the 'Open' column referred to the state of the account (whether an account is Open at the Start of Month).
スポイラ
And the Batch macro:
