Challenge #41: Analytics PayPeriodCalc

[mcultrera]

This was a fun one!

Spoiler

[Cosmin_S]

Attached.

[phottovy]

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

[Johnny_Analytics]

Spoiler

[rslopez2]

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

[Ioana_Radoveneanu]

Solved

Spoiler

[willdupre]

Good challenge. Quite a bit going on.

[Jonathan-Sherman]

Challenge 41 is done!

Spoiler

[rcor]

Spoiler