Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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
‎07-01-2023 11:56 AM
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 .

challenge_41_start_filemili.yxmd
Reply
0 Likes
Amy_smart
11 - Bolide
‎07-11-2023 03:00 PM

Here is my solution. 

challenge_41_7_11.yxmd
Reply
0 Likes
Sebastian_Chaieb2
9 - Comet
9 - Comet
‎07-24-2023 08:03 AM

Another possible solution ;)

 

Spoiler
Capture.PNG

 

challenge_41_Solution_SC.yxmd
Reply
0 Likes
H_a_n_g_C_h_e_n__x3
8 - Asteroid
‎07-24-2023 12:29 PM

Did it 2 ways. Second one is more efficient 

challenge_41_complete 7-24.yxmd
Reply
0 Likes
aroumpelaki
8 - Asteroid
‎07-31-2023 07:21 AM

Nice brain teaser!

challenge_41_ARsolution.yxmd
Reply
0 Likes
GabrielaTudor
8 - Asteroid
‎08-01-2023 02:32 AM
Spoiler
Challenge 41.jpg
challenge_41_G.yxmd
Reply
0 Likes
AndreeaS
8 - Asteroid
‎08-03-2023 12:16 PM
Spoiler
41.png

 

challenge_41_done.yxzp
Reply
0 Likes
mattnason1
9 - Comet
‎08-04-2023 10:15 AM

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

challenge_41_start_file.yxmd
Reply
0 Likes
DanielvanLeuzen
8 - Asteroid
‎08-08-2023 11:50 PM
Spoiler
Schermafbeelding 2023-08-09 085008.png

my solution

challenge_41_my_solution.yxmd
Reply
0 Likes
Carolyn
12 - Quasar
12 - Quasar
‎08-11-2023 01:12 PM

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

 

challenge_41_start_file.yxmd
Reply
0 Likes