Hello,
I have a requirement to calculate the distinct occurrence of an event based on the timestamp when it was accessed last. For eg, an event must be counted as a separate occurrence only if it does not occur in the previous 120 min(2 hour) interval. These events are counted on a weekly basis.
We have event Timestamp, Week start date based on which I am segregating data into weekly intervals. I am able to count the number of distinct occurrences but left confused on how to include the logic to check if any such event has occurred in last 120 minute interval.
Also wondering if this needs any logic inclusions/changes in RPD. Any pointers will be much appreciated.
Thanks in advance.
Yada.