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




      Would give these values


      Number Open Items


      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.