Challenge #62: Find the Duplicate Clicks

[ken_yap_au]

Done.

[shahryal]

Spoiler

Spoiler

[jagdeep_singh85]

PFA my solution

[JP23]

This is good one in that it tests out your ability to get the most out of the tools, as opposed to knowing which tools to use. As a beginner, it was relatively obvious which tools to use but putting them into practice effectively required me to develop a better understanding of alteryx syntax, particularly for the dates. Hopefully my solution can help others. Cheers. 

[bjkay30]

Here is my take.  After I finished, I realized you could probably do this with just one tool.

Spoiler

[mbogusz]

Spoiler

[SueDonim]

Getting better at Date and Time handling, but I suspect there was a more direct way to handle this

[EDIT: Duh! Don't know why I didn't use the DateTime tool]

Spoiler

Process:
- Grouped machine and user ID to allow simple grouping
- Parse date info
- Parse time info
- Recreate datetime in Alteryx format
- Multi-Row tool to calculate difference in time between clicks
- Flag instances where time difference was 30 seconds or less as "1" else "0"
- Clean-up

[ddiesel]

My solution:

Spoiler

[justindavis]

Spoiler

[RoDO]

My solution

Spoiler

IF ABS(DateTimeDiff(DateTimeParse([Row-1:EventFireDate],'%m/%d/%y %H:%M:%S'),DateTimeParse([EventFireDate],'%m/%d/%y %H:%M:%S'),'seconds')) < 30 Then 1 ELSE 0 ENDIF