Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #41: Analytics PayPeriodCalc

Highlighted
Asteroid

Here is my solution:

 

Spoiler
Alteryx Challenge 41 Solution.PNG
Highlighted

I'm still learning Alteryx, but I was shocked to find out that there wasn't a built-in function for this.  I thought about using generate rows, but that seemed like overkill; so I googled.

 

Spoiler
Thanks to this post (link) I was able to calculate it a formula tool.
challenge_41_completedScreen.jpg

Seems like this should be standard in Alteryx.

Highlighted
Asteroid

this was a though one!

 

Spoiler
image.png
Highlighted
Quasar
Spoiler
Challenge #41.PNG
Highlighted
Pulsar
Spoiler
image.png
Highlighted
Alteryx Partner

Shout out to Tool Mastery | Generate Rows for the helping solve this one. Glad there were more efficient solutions out there.

 

Here is my solution!

 

Spoiler
challenge_41_gm.PNG

 

 

Atom
 
Highlighted
Asteroid
 
Highlighted
 
Highlighted
Asteroid

Used the Formula tool Parse the date and month and get weekdays