Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You should have create the month field in the Load script.
Celambarasan
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
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