Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

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

AndyBate
8 - Asteroid

could have done this a lot simpler but wanted to use the opportunity to practice my macro builds. 

kelly_gilbert
13 - Pulsar

Good practice with date calcs. I'm bookmarking the formula provided by @Joe_Mako (via @jdunkerley79) in this post!

 

Spoiler
My solution:
Capture.PNG
jwlong91
8 - Asteroid

Fun challenge!  I believe I could have done this more efficiently now after having looked at the official solution, but it's cool to see how Alteryx can be used to tackle a problem from so many different ways.

KOBoyle
11 - Bolide

Solution attached.

JDelgado
8 - Asteroid

So this solution seems way more intricate than I would expect is necessary - there must be an easier way to differentiate between weekdays and weekend days, etc...

mickael_gest
8 - Asteroid

My solution :)

Wouter
8 - Asteroid

My solution:

 

Spoiler
challenge 41.jpg
JonM
8 - Asteroid
Spoiler
Ah, the power of Date Time Format, I which others had the same functions as what Alteryx provides!
gauravk
7 - Meteor

Here is my solution to challenge 41

STate
7 - Meteor

My solution