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 #62: Find the Duplicate Clicks

Highlighted
16 - Nebula
16 - Nebula

:-) pretty simple but fun

 

 

Highlighted
Alteryx Certified Partner

I seem to remember this was part of the certification exam, although I might be wrong. I've slept since then.

I think my solution will pretty much the same as the others.

 

Anyway, pretty straightforward:

 

Spoiler
I first converted the EventFireDate field to datetime using the Date Parsing tool. I then ordered them sequentially by this date and created a multi-row formula to determine like-for-like records that had a difference of 30 seconds or less from the previous line.
Then I simply sorted it accordingly.

Solution.PNG

Results.PNG
Highlighted
14 - Magnetar
14 - Magnetar

My solution!

Spoiler
WeeklyChallenge62.JPG
Highlighted
6 - Meteoroid

 

Solved this one with two tools. Although I added a few more at the end to check my work against the suggested output.

 

 

Highlighted
14 - Magnetar
14 - Magnetar

Nice easy one. Getting very comfortable with dates in Alteryx

 

Spoiler
Spoilerimage.png
Highlighted
Alteryx Certified Partner

A nice simple one

 

Spoiler
Weekly Challenge 62.png
Highlighted
7 - Meteor
 
Highlighted
Alteryx Certified Partner

Here's my solution.

 

Spoiler
challenge-62.png
Highlighted
Alteryx Certified Partner

Solution attached

Highlighted
16 - Nebula
16 - Nebula
Spoiler
Capture.PNG