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

This was a fun one!

Challenge 41.jpg

Attached.

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

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

Solved

Good challenge. Quite a bit going on.

Challenge 41 is done!

challenge 41 JMS solution.PNG

curated machine learning resources