Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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