Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #456: Holiday Side Hustle Earnings

wbasuki
8 - Asteroid

My Solution

Spoiler
Screenshot 2025-01-21 120034.png
Smatthias
7 - Meteor

I spent so much time getting confused by the american time format 👻

Spoiler
ch456.jpg

alineruizcampos
8 - Asteroid
Spoiler
Screenshot 2025-01-23 115235.png
pilsworth-bulien-com
13 - Pulsar

My solution:

Spoiler
456.png

lwolfie
11 - Bolide

Almost had this one work on the first try.  One tiny typo.

blairmbailey
8 - Asteroid

Solution attached! Thank you!

mgaronson
11 - Bolide
Spoiler
Challenge 456 Workflow Pic.png

 Trick is to figure out day of week in formula.

myastarling
11 - Bolide

Here's my solution!

Carlithian
11 - Bolide
11 - Bolide
Spoiler
Completed Challenge 456.jpg

Happy Alteryxing
Ryan-Yeung
7 - Meteor

Formula Based Solution, Could probably even do this skipping the generate rows and just calculating the number of weekdays and weekends within the formula from the start and end dates and do a 1 tool solution but this one is fairly elegant too.

 

Challenge 456 Solution.png

 

Challenge 456 Generate Rows.png

 

 

Challenge 456 Formulae.png