4 Replies Latest reply: Mar 18, 2013 1:23 PM by Eric Hewitt RSS

    Comparing Values with Different Calendars

      I have two fact tables, each with a separate date, and also joined by another dimension. I've got a date island built, and I use that for my filters without issue.

       

      Where my problem lies is when I need to use the measures in the same chart. For example, I need to divide the measure from one table (a count) by the measure in the other (hours). I can't seem to figure out how to get the measure to work in a chart with a date that it doesn't belong to. I've tried:

       

      sum(if(Count_Calendar.MonthYearNum = Hours_Calendar.MonthYearNum, Count))

      sum({<Count_Calendar.MonthYearNum={Hours_Calendar.MonthYearNum}>}Count)

       

      ...and others. Anyway, how do I get a chart to work correctly in this case?