Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

willstom1
8 - Asteroid

Here is my solution:

 

Spoiler
Alteryx Challenge 41 Solution.PNG
OldDogNewTricks
10 - Fireball

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.

MattKing
8 - Asteroid

this was a though one!

 

Spoiler
image.png
kat
12 - Quasar
Spoiler
Challenge #41.PNG
danrh
13 - Pulsar
Spoiler
image.png
gmartin
7 - Meteor

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

 

 

creasa17
5 - Atom
 
Inactive User
Not applicable
 
jeniferpeden
7 - Meteor
 
Vinutha
8 - Asteroid

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