http://forums.visokio.com/discussions/tagged/lookback_windows/feed.rss Mon, 30 Oct 17 16:12:39 -0400 Tagged with lookback_windows - Visokio Forums en-CA http://forums.visokio.com/discussion/2678/formulae-subset-functions-record-count-within-lookback-window-records-between Mon, 11 Aug 2014 05:31:16 -0400 alexandervolk 2678@/discussions
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.

Are there other ways to get the results I need?

Thanks for your help!
Alex]]>