3 Replies Latest reply: Mar 2, 2012 9:06 AM by l33h0885 RSS

    Line Graph - 2 date fields as same dimension

      Hi All,

       

      I have 2 tables - one with date, type and value, the other with month and % (actual and target respectively).

       

      I can use monthname(date) to get the date to match the month, but is there a way to link the two as a dimension?

       

      Basic layout of my chart is sum(value) by month (full accumulation) as one line, cumulative % by month as another.  As the target is only given in months, there isnt an exact date to match against.  I've not got my heart set on line so if this can be done as bar or mixed I am happy to change...

       

      Thanks for any insight.

       

      Lee