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

mcultrera
8 - Asteroid

This was a fun one!

 

Spoiler
Challenge 41.jpg
Cosmin_S
8 - Asteroid

Attached.

piotrzawistowski
8 - Asteroid
 
phottovy
13 - Pulsar
13 - Pulsar

Trickier than I thought it would by. I'm sure there are better ways of calculating this.

Johnny_Analytics
8 - Asteroid
Spoiler
Challenge_41.png
rslopez2
8 - Asteroid

Probably could have done it a bit cleaner - But got there!

 

-Added Record Number

-Transpose to get Dates all in one Column for Date conversion

-Convert to Date Format

- Split workflow

  -upper Workflow get Month Year by record number

  -lower workflow Isolate P1 & P2 Records

  -Generate Rows to get dates between Start and End Periods

  -Convert generated dates to "Weekday" Values & Flag Weekend Days

  -Filter Out Weekend days

 -Group and Count Weekdays for P1 & P2 values

-Join P1 & P2 Values by record number back to original Set.

-Join back to original 

 

Spoiler
RL_challenge_41.png
Ioana_Radoveneanu
8 - Asteroid

Solved

 

Spoiler
41.png
willdupre
7 - Meteor

Good challenge. Quite a bit going on.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 41 is done!

 

Spoiler
challenge 41 JMS solution.PNG

 

 

rcor
8 - Asteroid
Spoiler
challenge_41_RC_solution.PNG