0 Replies Latest reply on Jun 27, 2014 9:05 AM by Dobson

    Date Bin Using Start Date and Date Count

    Dobson

      I have a data set that only includes the date of an admit and how many consecutive days that admit occurred for each member.  I am trying to see how many admit days occurred in each month.  For example, If a member has an admit date of 1/20/2014 and a day count of 15,  Then 12 days should be attributed to January and 3 days to February.  Then end result should be monthly bins with total number of admit days for all members in them.

       

      No sample viz, but sample data attached.

       

      Thanks,

      Josh