Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #41: Analytics PayPeriodCalc

Highlighted
8 - Asteroid

I used a different approach with two different data streams, generating rows for all days inbetween start and end, checking if they are weekdays (=1) or not (=0) and summarize all, putting the streams together by record id set on start.

Spoiler
Sylvana_0-1589358863591.png

 

Highlighted
Alteryx Partner

I think I like DateTimes challenges

Highlighted
Alteryx Partner

Number 10

Spoiler
sumanthskumar_0-1589646179442.png
Highlighted
8 - Asteroid

Hi,

 

Sharing my solution.

 

It is really sad that it is much more complicated than it should. There should be some user friendly functions that would allow to make calculations in seconds instead I needed to create a workaround. 

 

I saw that people posted solutions that are simpler and faster but still it looks like in this case Alteryx don't have some basics functionality to provide the answer easily.

 

Spoiler
Challenge_41_Emil_Kos.PNG
Highlighted
8 - Asteroid

Great challenge! Learned a lot, maybe my solution has a lot of steps but I think it works. Left my results sorted by date. My solution attached.

 

Spoiler
Challenge_41_edavilac.PNG
Highlighted
8 - Asteroid
Spoiler
JohanRanschaert_0-1590498866588.png

 

In attach my solution

Highlighted
7 - Meteor
Spoiler
MarielJinang14_0-1590847949063.png

 

Highlighted
11 - Bolide
Spoiler
 
Highlighted
7 - Meteor

Here you go !!

Highlighted
12 - Quasar
12 - Quasar

Took quite a few more tools than i initially though...

Spoiler
jarrod_0-1591104694609.png