community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #62: Find the Duplicate Clicks

Quasar
Spoiler
Challenge #62.PNG
Asteroid

My solution to challenge #62 is attached.

Highlighted
Alteryx Partner
Spoiler

challenge 62.PNG

Could be done in one tool, but hey

Alteryx Partner

That felt nice after the last one which had my brain boiling.

I am sure I could have made it in one tool, but could not manage to get my date formats right within the multi row formula.

 

Spoiler
Challenge 62 spoiler.PNG

Solution attached.

Asteroid

My solution.

Bolide

Cheers!

Alteryx Certified Partner

Short and sweet :)

Asteroid

 

Intermediate might be somewhat of a stretch to solve this one. :)

I solved the challenge using 2 tools. I guess one could have parsed the EventFireDate directly in the Multi-Row Formula tool, but for sake of simplicity, I went for the 2 tool solution.

 

Spoiler
challenge_62_start_file_MarMu.png
Meteor
Spoiler
2018-10-15_10-45-02.png