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

GuiLikeTheButter
8 - Asteroid
Spoiler
WC_461.jpg
Tofel
8 - Asteroid
Spoiler
Challenge 461.jpg

alexgibson
7 - Meteor

Fun challenge this week!

 

 
Spoiler

Screenshot 2025-01-27 091246.png

binuacs
21 - Polaris
Spoiler