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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #62: Find the Duplicate Clicks

Quasar
Spoiler
Challenge #62.PNG
Asteroid

My solution to challenge #62 is attached.

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.

Highlighted
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
Asteroid
Spoiler
2018-10-15_10-45-02.png