Weekly Challenges

KaneG · ‎09-28-2021

Nice quick one

DanTh · ‎10-01-2021

Spidey senses were tingling on this one!

Figured it must be possible with a single Multi-Row Formula tool:
IF
DateTimeDiff(
DateTimeParse([EventFireDate],"%m/%d/%y %H:%M:%S"),
DateTimeParse([Row-1:EventFireDate],"%m/%d/%y %H:%M:%S"),
"seconds") <= 30
THEN "1"
ELSE "0"
ENDIF

5/5

Figured it must be possible with a single Multi-Row Formula tool:IFDateTimeDiff(DateTimeParse([EventFireDate],"%m/%d/%y %H:%M:%S"),DateTimeParse([Row-1:EventFireDate],"%m/%d/%y %H:%M:%S"),"seconds") <= 30THEN "1"ELSE "0"ENDIF 5/5

euanwilson · ‎10-04-2021

Spoiler

rohankusuma · ‎10-11-2021

my_solution

Anmol97 · ‎10-17-2021

Here's my solution

TheOC · ‎11-02-2021

Quite a fun challenge! I feel like i could potentially make this a 1 tool challenge!

Spoiler

juliabarale002 · ‎11-30-2021

🖱

LiuZhang · ‎12-08-2021

Spoiler

The data seems to be sorted already, so not much needed other than multi-row formula tool.

atasi_jain · ‎12-10-2021

Solution

BSilverblatt · ‎12-13-2021

Thanks for the challenge! Here is my solution:

Weekly Challenges

IDEAS WANTED

Challenge #62: Find the Duplicate Clicks