This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
2022.1.1.30569 Patch Release Update
The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs.
If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.
A solution to last week’s challenge can be found here.
The International Bank of Awesome Data (IBAD) leadership team has been impressed with your work so far in helping to clean up the data extracts from their various bank branches. But now they want to get to the good stuff – the reporting & analytics.
Each IBAD bank branch reports data up to their Assistant to the Regional Manager, and we’ve been tasked with helping them out with this data reporting (acting as Secret Assistants to the Regional Manager, if you will). The Assistant to the Regional Manager is determined by a combination of Region and the first 3 digits of the Bank Branch ID, with the mapping file provided. All Assistants to the Regional Manager want to receive the same summary statistics by branch – Opening Balance, Debits, Credits, Ending Balance, Avg Daily Balance, % Change, and Count of Customers throughout the month.
Should you choose to accept this challenge, your task will be to create a batch macro that will generate customized individual output data sets for each Assistant to the Regional Manager, summarizing these metrics by Bank Branch as well as overall for each Assistant to the Regional Manager.
- Step 1: Identify the Assistant to the Regional Manager for each Bank Branch based on Region & the first 3 digits of the IBAD Bank Branch ID - Step 2: Create a batch macro ** that will calculate the required metrics by bank branch as well as overall for each Assistant to the Regional Manager - Step 3: Output should be a unique YXDB file for each Assistant to the Regional Manager with all the metrics for their branches (refer to the format in the output example)
HINT: To calculate the avg. daily balance, you will need to add daily debits/credits, including $0 on days where there are no transactions. Generate Rows tool + Multi-Row field will likely be your friends here…
** Yes, we realize you could also probably do this without a batch macro, just by using some of the grouping functions within various tools… but that’s not as much fun, is it?? **