Free Trial

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

mithily
8 - Asteroid
Spoiler
Spoiler

I used generate rows to get each of the days in between and then got the name of the weekday and filtered out the sat-sun and then did a count and joined by position to provided solution to check if I got it right .

Amy_smart
11 - Bolide

Here is my solution. 

Sebastian_Chaieb2
11 - Bolide
11 - Bolide

Another possible solution ;)

 

Spoiler
Capture.PNG

H_a_n_g_C_h_e_n__x3
8 - Asteroid

Did it 2 ways. Second one is more efficient 

aroumpelaki
8 - Asteroid

Nice brain teaser!

GabrielaTudor
8 - Asteroid
Spoiler
Challenge 41.jpg
AndreeaS
8 - Asteroid
Spoiler
41.png

 

mattnason1
9 - Comet

This one was fun.  And I think my workflow was pretty efficient on this one.

DanielvanLeuzen
8 - Asteroid
Spoiler
Schermafbeelding 2023-08-09 085008.png

my solution

Carolyn
12 - Quasar
12 - Quasar

Completed. I started by combining P1 and P2 into a single list since I see that better than in separate columns

 

Spoiler
2023-08-11 13_10_59-Alteryx Designer x64 - challenge_41_start_file.yxmd_.png