2 Replies Latest reply on Jun 6, 2014 4:42 PM by Shawn Wallwork

    time series on items between a start and end date

    John King

      I have columns item_ID,  start_date,  and end_date. An item was active during a time period between its start_date and end_date. I want to see how my active items vary monthy and quarterly. That is I want to get the historical view at a period in the past. How could I do that?

       

      So... these data

       

      itemopenDatecloseDate
      11/1/20144/1/2014
      22/1/20143/1/2014
      33/1/20144/1/2014

       

      Would give these values

       

      Number Open Items
      JanFebMarApr
      1232

       

      I can create a calculated field that counts items opened + items. I can view that sum on a monthly basis ... that gets me part way there. But it doesn't get me the items that are open during a month, but were not opened or closed during that month.