I have tried a few different dimensions to get what I am after but each has a problem with it. 1: If I use the month for the dimension it will separate by months but not years. 2: If I use the year, it will separate the years but not the months. 3: If I use the Month/Year combination with the following calculation Date(makedate(year(AdmitDate),month(AdmitDate)),'MMM-YYYY') AS MonYear, It will separate the months and years as I want but If a visit crosses from one month into the next, all days from this visit will go in the starting month.
I the inline table below Jan-2010 should = 3 Feb-2010 should = 3 Jan-2011 should = 3 ( it shows 4) Feb-2011 should =2 (it shows1)
The fifth line in the table has a date range that crosses from Jan to Feb. The strange thing is I had this part working when I was using the month as the dimension.
%%%% Question on Forum Procedure %%%%%%%%%%%%%%% I asked this questions previously, received an answer and verified it. Since then I found an exception that I need to handle. In the future do I reopen the old thread somehow or start a new one?