Ideal Model for Visualization Friendly

[Anonymous]

Hi folks...

At this time I would like to ask your opinion for the following situation...

I have compare the real situation vs plan previously created

DATA REAL:

ID_REAL	NAME	DATE_START	DATE_END	ID_LINK
01	TASK 1	15/01/2015	31/01/2015	01
02	TASK 2	15/01/2015	15/02/2015	02
03	TASK 3	01/02/2015	28/02/2015	03
04	TASK 4	01/05/2015	20/05/2015	04
05	TASK 5	01/03/2015	31/03/2015	--
06	TASK 6	01/04/2015	15/04/2015	--

DATA PLAN:

ID_PLAN	NAME	DATE_START	DATE_END
01	TASK 1	01/01/2015	31/01/2015
02	TASK 2	01/01/2015	31/01/2015
03	TASK 3	01/02/2015	28/02/2015
04	TASK 4	01/02/2015	31/03/2015

I need compare this data, but need resolve first the selectors (type:date) in the application...

for example, if i compare in graphs for month, how much tasks have planned starting? and how much really started? and how much task are in process, how much task are terminated for month...

if i do with date Start in graph the data show correctly if i want see the number of task are started for month,

if i do with date End in graph the data show correctly if i want see the number of task are finished for month,

but i need available 2 selectors (DATE END and START) ans two graphs

how could be only one selector and one graph?

actually i tried make a master calendar with MIN(date start) and MAX(data_end) and join the data REAL with data PLAN in one table...

i need help or any advice for make my model ??

thanks in advance

[#2]

I would concatenate into a single table, with a field to identify "real" vs "plan":

Data_Real_Temp:
LOAD * INLINE [
ID_REAL, NAME, DATE_START, DATE_END, ID_LINK

01, TASK 1, 15/01/2015, 31/01/2015, 01
02, TASK 2, 15/01/2015, 15/02/2015, 02
03, TASK 3, 01/02/2015, 28/02/2015, 03
04, TASK 4, 01/05/2015, 20/05/2015, 04
05, TASK 5, 01/03/2015, 31/03/2015, --
06, TASK 6, 01/04/2015, 15/04/2015, --
];

Data_Plan_Temp:
LOAD * INLINE [
ID_PLAN, NAME, DATE_START, DATE_END,

01, TASK 1, 01/01/2015, 31/01/2015,
02, TASK 2, 01/01/2015, 31/01/2015,
03, TASK 3, 01/02/2015, 28/02/2015,
04, TASK 4, 01/02/2015, 31/03/2015
];

Data:
LOAD ID_REAL AS ID,
NAME,
DATE_START,
DATE_END,
'Real' AS FactType
Resident Data_Real_Temp;
Concatenate
LOAD ID_PLAN AS ID,
NAME,
DATE_START,
DATE_END,
'Plan' AS FactType
Resident Data_Plan_Temp;

DROP TABLES Data_Real_Temp,Data_Plan_Temp;