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