1 Reply Latest reply on Mar 26, 2017 1:38 PM by Yuriy Fal

    Conditional Counting For Independent Time Periods

    kain petterson



      I'm having trouble figuring this out; any help would be appreciated.


      I have a list of statuses with unique timestamps with a start and end timestamp for each status. I am looking to plot times on the x-axis at an increment independent from anything in the database (ideally user specified) - for example: 20 minute increments from 6:00 am to 6:00 pm-. For each time interval, I'd like to count the number of items that were in a certain status (i.e: number of carts down between 6:00 and 6:20 on a given day).


      What would be the best way to attack a problem like this?