Line Graph - 2 date fields as same dimension

[#1]

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

[CELAMBARASAN]

Hi,

     You should have create the month field in the Load script.

Celambarasan

[#3]

Hi,

Do you mean in the load script have monthname(date) as target_month and then load the target month as target_month, thus linking the two?

That sounds like ti should work - only basing the chart on one field which is shared by both tables. Genius!

Thanks Celambarasan

Lee

[#4]

Ok, new problem.

I now need to find the difference between two dates (easy), but I need to calculate this within the load script.  If the two dates are on seperate tables, can this be done?

Thanks