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

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

This solution to last week's challenge can be found HERE.

 

A website log tracks every click visitors are making on a particular link on the site in order to measure interest in the link.

However, web consumers are impatient and may click a link multiple times in short succession.

The goal of this exercise is to flag "duplicate clicks" that is defined as the event fire date happening within 30 seconds of the previous event fire date for the same user (IDFA) and device (DeviceID)

Bolide

not sure if I arrived early, but there was no workflow attached to your post.

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

@alex, the start file is now posted!

Alteryx Certified Partner
Alteryx Certified Partner

@JoeM,

 

I included a sort (to make sure that data is in time order).  Your challenges almost make Monday's something to look forward to..

 

Cheers,
Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.

Bolide

Looked for a way to do it differently than @MarqueeCrew, but couldn't.  My workflow was the same as his.

Alteryx Certified Partner

I went a longer way around on the date parsing but got there in the end. I also assumed the data was pre-sorted from eyeballing the data.

 

Nice short challenge.

Meteor

Hi guys, solution attached. this week was pretty straight forward, have a great week!

thank you

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

@MarqueeCrew... the critical word being "almost".  ;) 

 

 

Atom

Fairly simple one I believe.

Alteryx Certified Partner

Took a while to write the expression, but quite a simple one.