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 #41: Analytics PayPeriodCalc

adams_ca
8 - Asteroid

With thanks to 

Spoiler
#41 Solution.JPG
dharini
8 - Asteroid

long-winded perhaps but was in no mood to make it efficient

Alekh
9 - Comet

I had to download the custom business day formula posted on the community to solve this one. Made it a lot simpler.

 

 

Spoiler
41..png
AntonioGonzales
8 - Asteroid

Solved.

I didn't think this a beginner task. :-)

Spoiler
41.png

Very good exercise.

Cheers!

 

Antonio Alves

 

 

KaneG
Alteryx Alumni (Retired)

Split periods into separate paths and then stack them.

 

Spoiler
Challenge41.png
Karam
8 - Asteroid

Good practice.

I think it's fair to categorise it as an intermediate exercise :)

 

Spoiler
challenge 41.PNG
CapriceW
8 - Asteroid

Here goes!

bradley_slaughter
8 - Asteroid

I feel like my answer was far more complicated than others in the thread but seems to work out to get the answer.

Steven_Pocoroba2
8 - Asteroid

Solution attached, that was fun thanks!

catarina_pimpao
8 - Asteroid
Spoiler
AWC_41.PNG