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

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1677062869716.png

 

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1677156228362.png

 

jerviss53
8 - Asteroid

Solution Attached

CeliaC_Silje
8 - Asteroid

I think this can be done in 1 data stream, but still decided to split into 2 for troubleshooting

Spoiler
CeliaC_Silje_0-1678267444282.png
akorte1
8 - Asteroid

Done

elaineyuan
8 - Asteroid

Maybe I went overboard with the DateTime tool. 😅

 

Spoiler
challenge_41_elaine_yuan.png
PrachiD
8 - Asteroid

solved using DateTimeParse Formula, generate Row, DateTime, Summarise etc

Hammad_Rashid
11 - Bolide

41 solution.PNG

dougbaron
8 - Asteroid
Spoiler
dougbaron_0-1680017632275.png

 

Spurs
8 - Asteroid
Spoiler
Spurs_0-1680780345869.png