I need a total for each month for each year to appear on the chart. If I use the Year as the dimension I can separate the two years but the months are lumped together. If I use the month then the months separate but years do not. I tried using a month year and I also get funny results.
For example, on the attached qvw I am using the month as the Dimension and I see bars for Jan and Feb. I need to bars for Jan and Feb for both 2010 and 2011. I think I am being a little thick today.
Well your instinct was right, you need to use month-year or year-month (or drill down from year to month). But it looks like your Month-Year field is miscalculated. Use this for your MonthYear: date(makedate(year(AdmitDate),month(AdmitDate)),'MMM-YYYY') as MonthYear
Well your instinct was right, you need to use month-year or year-month (or drill down from year to month). But it looks like your Month-Year field is miscalculated. Use this for your MonthYear: date(makedate(year(AdmitDate),month(AdmitDate)),'MMM-YYYY') as MonthYear
