View Single Post
 
Old 07-27-2016, 11:31 PM
DominionSoup DominionSoup is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jul 2016
Posts: 1
DominionSoup is on a distinguished road
Lightbulb How to create time series plots with spans?

So i am trying to create a time series plot that catalogues the number of items on each day over a span of time. For example, I have an operation that begins on 2/3/16 and ends on 4/5/16. I would like this operation to be counted in my time series plot every day between those two dates. In reality, I have like 600 of these time spans that I want on a time series plot (by week) where the operation is counted every day it is in use.

So let's say I have three spans: 2/3/16-4/5/16; 2/12/16-4/7/16; 2/27/16-5/2/16. If I were to look at my time series plot on the day on 2/4/16 it should show a quantity of one. If I were to look at it on 2/15/16 it should show a quantity of two. If I were to look at it on 3/18/16 it should show a quantity of three. If I were to look at it on 4/6/16 it would show a quantity of two. For any day/week I choose between these dates it should show me how many operations I have. How do I do this?
Reply With Quote