cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #62: Find the Duplicate Clicks

JoeM
Alteryx Alumni (Retired)

Challenge #62: Find the Duplicate Clicks

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)

Attachment
Download this attachment
Attachment
Download this attachment
Dominic_Brady
Asteroid

Re: Challenge #62: Find the Duplicate Clicks

my solution. Took me way too long to see that the event fire date needed converting for my datediff to work...

Attachment
Download this attachment
Pilsner
Pulsar

Re: Challenge #62: Find the Duplicate Clicks

My solution:

Spoiler
62.png

Attachment
Download this attachment
JBevan89
Asteroid

Re: Challenge #62: Find the Duplicate Clicks

Easy one, but good to see the Multi-Row formula tool again

Attachment
Download this attachment
TGreen
Asteroid

Re: Challenge #62: Find the Duplicate Clicks

Done.

Attachment
Download this attachment
RebekaMazuchova
Asteroid

Re: Challenge #62: Find the Duplicate Clicks

Smiley Happy

Attachment
Download this attachment
mattnason1
Comet

Re: Challenge #62: Find the Duplicate Clicks

I like this one, if I was better at date functions I probably could have done all in a single multi-row.  But oh well. Smiley Happy

Attachment
Download this attachment
Dhrish
Asteroid

Re: Challenge #62: Find the Duplicate Clicks

Solution

Attachment
Download this attachment
Raphael_Lechenauer
Meteoroid

Re: Challenge #62: Find the Duplicate Clicks

quick one

Spoiler
Raphael_Lechenauer_0-1750686876623.png

 

Attachment
Download this attachment
Highlighted
lley124
Meteor

Re: Challenge #62: Find the Duplicate Clicks

Here is my solution.

Attachment
Download this attachment