I have a set of timestamped data (page visits) in which - for each record - I want to calculate the number of page visits within the last N minutes. I have a device which sets N as a parameter, defaulted to 5 minutes.
In a second field next to "timestamp", I am calculating "timestamp-N" for the lookback window. My initial idea was to use the RECORDCOUNT formula and for each record, calculate the record count between MIN[timestamp-N] and MAX[timestamp]. That doesn't seem to work ...or at least I can't get the formula right.