Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Subset Functions-Record count within lookback window/ Records between - Visokio Forums
Formulae: Subset Functions-Record count within lookback window/ Records between
  • alexandervolk     alexandervolk August 11, 2014 5:31AM
    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.

    Are there other ways to get the results I need?

    Thanks for your help!
    Alex
  • 1 Comment
  • alexandervolk     alexandervolk August 11, 2014 8:30AM
    Solved with:

    RECORDCOUNT(SUBSET2([Timestamp],[Timestamp],[Timestamp-N],[Timestamp],">=","<="))
This discussion has been closed.
← All Discussions

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership