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?