Hi everyone,
I have a problem when I try to create the chart with headcount over years.
I have a employee profile table like this:
EMP_ID EMP_HIRE_DATE EMP_TERM_DATE
001 01-Feb-2010 31-Dec-2010
002 01-Mar-2010 31-Oct-2010
In my chart, I want the x-axis showing headcount from Jan 2010 to Dec 2010.
Using the above data,
In Jan 2010, should show 0 in the chart, while 1 in Feb 2010 and 2 in Mar 2010.
I created a calendar table which include date, month, year which covers from 1-Jan-2010 to 31-Dec-2010.
But I have no idea on how to connect my "employee profile" table with my calendar table.
I only can finish my graph by allowing no relationship between two tables.
But it has a very low performance when my calendar table extends and i get more employee records.
Anyone has ideas on it??
Thanks!