ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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

Linas
8 - Asteroid
Spoiler
Linas_0-1681400675299.png

 

Ray_Pospisil
8 - Asteroid

this took longer than I expected

gaoa
11 - Bolide

My easy solution: 

 

Spoiler
gaoa_0-1682015257714.png
NMangera
11 - Bolide
Spoiler
NMangera_0-1682091752310.png

 

TA

1.  functions: can be combined with the generate rows tool (removing the need for an additional formula tool)

2. design pattern: recordID tool to the left of join to keep track of records

Archie_bos
8 - Asteroid

here is my solution

mgaronson
11 - Bolide
Spoiler
mgaronson_0-1682712339073.png

So many ways to do this challenge! This could be more streamlined as I duplicate flows to do the weekday calcs.

tmich20
8 - Asteroid
Spoiler
tmich20_0-1683443176705.png

 

jennifer_owens
8 - Asteroid

This took longer to figure out than I thought due to the dates with 1 day. Looking forward to reviewing others' work. 

chandler-gjino
Alteryx
Alteryx

Attaching my solution

harrame
8 - Asteroid
8 - Asteroid
Spoiler
harrame_0-1684257099978.png