ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

AndrewHoData
8 - Asteroid

Took a while to figure out but got there with some guidance from 
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Calculate-Business-Days-Between-Dat...

 

Spoiler
Don't know how to not use 4 DateTimeParseDon't know how to not use 4 DateTimeParse

 
Would be nice not use 4x DateTimeParse tools. Anyone know any shortcuts?

If anyone knows any quicker ways than I have provided, let me know!

 

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1660743576584.png

 

lkim524
8 - Asteroid

got it done but probably could have done it more efficiently...

BenoitC
Alteryx
Alteryx

Fun challenge!

 

Spoiler
BenoitC_0-1660828970931.png

 

Benoit Conley

Sales Engineer
Alteryx, Inc.

chara123
8 - Asteroid

Here is my solution

challenge 41.png

ahsanaali
11 - Bolide
Spoiler
Spoiler
ahsanaali_0-1661494843572.png

 

MilindG
12 - Quasar

Solution 41

grazitti_sapna
17 - Castor

grazitti_sapna_0-1662097746832.png

 

Sapna Gupta
karlhansen
9 - Comet
Spoiler
solution_41.jpg
pmyers
Alteryx
Alteryx

My solution attached.