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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #62: Find the Duplicate Clicks

JoeM
Alteryx Community Team
Alteryx Community Team

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)

alex
11 - Bolide

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

JoeM
Alteryx Community Team
Alteryx Community Team

@alex, the start file is now posted!

MarqueeCrew
19 - Altair
19 - Altair

@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.
alex
11 - Bolide

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

Balders
10 - Fireball

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.

Max06270
7 - Meteor

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

thank you

JoeM
Alteryx Community Team
Alteryx Community Team

@MarqueeCrew... the critical word being "almost".  😉 

 

 

csmilley
7 - Meteor

Fairly simple one I believe.

vuddagiri1991
5 - Atom

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