Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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

cadyb
Alteryx
Alteryx

My solution!

KatyP
7 - Meteor

Took me a little while to figure this out but got there eventually. It is a little different to the given solution but it seems to do the job. Thanks!

ipeng
8 - Asteroid

Solution Attached!

EW
11 - Bolide

My solution with 13 tools including in/out:  

 

Spoiler
All the crosstabs and transposes make me think there's a better way with fewer tools maybe?  This seems to get the right result though:

041EW.PNG

 

ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.PNG

 

RolandSchubert
16 - Nebula
16 - Nebula

My solution

AJauniskis
8 - Asteroid

A bit over-complicated solution, but it works

 

Spoiler
workflow.JPG
T_Willins
14 - Magnetar
14 - Magnetar

I like to work through challenges before looking at other's solutions, so I now see other solutions that are more elegant.  Great proof of all the different ways you can get after data to get the right answer!

AndrewLehm
8 - Asteroid
 
RichoBsJ
11 - Bolide

Hi! Here my solution :)