In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

NurulShi12
8 - Asteroid

My solution:

 

Spoiler
NurulShi12_0-1571943442047.png
PhilBalderson
8 - Asteroid

Learned a lot about datetime calcs here! 

apabonok
8 - Asteroid

Hi. This is my solution.

 

-Convert start and end fields, to date

-Generate rows for days from P1 Start to P2 End.

-Calculate for: Month field, exclude weekend, sum days

-Group by Month and Sum days 

JamesFo
8 - Asteroid
 
ConradW
8 - Asteroid

Complete

CailinS
Alteryx Alumni (Retired)

The Customer Support team in Plano, TX holds weekly lunch and learns where we build these out and share our solutions. Super fun! thanks @MargaritaW for leading this awesome learning session!

 

Spoiler
CailinS_0-1573237691699.png
Cailin Swingle
Customer Experience
MargaritaW
Alteryx Alumni (Retired)
 
Margarita Wilshire
Sr. Manager, Customer Support Engineering
Women & Allies Committee


Alteryx, Inc.
AmeliaG
Alteryx
Alteryx
Spoiler
41_screenshot.png
Borja_Leiva
7 - Meteor

My solution

Inactive User
Not applicable