Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

nickjastrzebski
8 - Asteroid

Good practice with date parsing and generate rows here.

Spoiler
image.png
gautamsawant93
7 - Meteor

Here's my solution, this one sure took a lot of time for me. Not exactly a beginner level challenge I felt.

garthn555
8 - Asteroid
Spoiler
gn_challenge_41.png

My solution - pretty much the same as the original one

joemkcarr
8 - Asteroid
 
joshuaburkhow
ACE Emeritus
ACE Emeritus

Was able to do this with two tools!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
klyuka
8 - Asteroid

Brute force without Alteryx beauty, but logical expression.

Spoiler
D_1 - day of week of first day in a month

P_1 = 10 + iif([D_1]<6,1,0)

P_2 = 20 - [P_1]+
iif([days]>28,1,0) * iif(([D_1]=6) OR ([D_1]=7),0,1)+
iif([days]>29,1,0) * iif(([D_1]=5) OR ([D_1]=6),0,1)+
iif([days]>30,1,0) * iif(([D_1]=4) OR ([D_1]=5),0,1))
Hannah_Lissaman
11 - Bolide

My solution 🙂

Treyson
13 - Pulsar
13 - Pulsar

Boom! Love any chance I get to use the 'Create Rows' tool. 

Treyson Marks
Senior Analytics Engineer
Greg_Murray
12 - Quasar

Solution attached

ganeshnaicker
7 - Meteor

use this in one of the case while training hence used multiple datetime tool. Could be done using single formula tool