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

Suzu
9 - Comet

Here is my solution.

Sidey1978
8 - Asteroid

I used a calendar macro.... Is that ok in these challenges?!

georgetardy
6 - Meteoroid

Here's my solution, with no crosstab or transpose used.
I used ponraj's workflow on calculating business days as an inspiration, although I didn't open it  only used his screenshot.

martensite
8 - Asteroid

My solution! Output is a little diff but more accuracy I think

BradWerner
11 - Bolide

Cool to learn how the Generate Rows tool can dynamically fill in dates.

 

Spoiler
41Flow.PNG
DanielMS
Alteryx
Alteryx
Spoiler
Spoiler.PNG
jdemeaux
8 - Asteroid
 
Abell
7 - Meteor

This one challenged me a bit 

ctrl_kudorje
8 - Asteroid

Great challenge!

abinder
6 - Meteoroid

Solution attached