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
Become a Viz Whiz on the Forums! Support the Community and master Tableau.