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