Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

jamielaird
14 - Magnetar

FYI @JoeM - the start file is missing the bundled data and (very generously) includes a solution.

 

I created a new start file using the most recent posted solution so you can switch out the files.

jamielaird
14 - Magnetar

Here's my solution.  Very pleased with the Generate Rows tool that increments by day between the Start and End dates - incredibly satisfying.  I can see that others managed to use fewer tools but this did the job nicely for me.

 

Spoiler
challenge-41.png

 

nick_ceneviva
11 - Bolide

Solution Attached

patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
marcreid
7 - Meteor

Solution

Spoiler
image.png
Natasha
9 - Comet

I remember the joy I had a while ago when I finally figured out how to make 'Generate row' tool to work with dates.

Spoiler
Screen Shot 2017-10-29 at 19.13.21.png
JoshKushner
12 - Quasar

For 'beginner' level difficulty this was particularly tricky. Quite enjoyed the double cross tab.

samN
10 - Fireball

Pretty round about method but got there in the end. 

ggruccio
ACE Emeritus
ACE Emeritus

Lots of steps, but got the results.

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
challenge_41 - Snip.PNG