In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
Free Trial

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

Challenge #461: Accounting Payment Calendar

AYXAcademy
Alteryx
Alteryx

Weekly Challenge LMS Banner.png

 

Hello Community members!

 

A solution to last week’s challenge can be found here

 

This week’s challenge was submitted by Jay Zhen @jialiangzhen . Thank you, Jay, for this great challenge!

Imagine you work for a large organization’s accounting department. You are responsible for organizing the payment schedule for the year based on specific dates.

pexels-tima-miroshnichenko-6694543.jpg

 

The entire company’s payments must be completed by the 6th workday of each month. You want to use Designer to organize a schedule for the entire year. The provided dataset contains the 2024 calendar and company holidays. Your task is to determine when the 6th workday is for each month in 2024. A workday is defined as any weekday from Monday to Friday (excluding company 

holidays).

 

Note: If you get stuck, check out the Hints box included in the workflow.

 

Need a refresher? Review the following lessons in Academy to gear up:

Joining Data

Numeric Functions

 

Good luck!

The Academy Team

 

Download Start File

 

Download Solution File

BransonJamesFarley
8 - Asteroid
Spoiler

 Could be optimized 😂

461.PNG

 

BransonJamesFarley
8 - Asteroid

Also appears to possibly be some slight errors with the given solution? For example the tenth month is a repeated "1". Fun challenge though!

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
461.jpg
Bobbyt23
12 - Quasar

Good challenge. Could definitely have used less tools!

Spoiler
image.png
griffinwelsh
12 - Quasar

My solution

Bennu
8 - Asteroid
Spoiler
WC_461.jpg
Tofel
9 - Comet
Spoiler
Challenge 461.jpg

alexgibson
7 - Meteor

Fun challenge this week!

 

 
Spoiler

Screenshot 2025-01-27 091246.png

binuacs
21 - Polaris
Spoiler