1 Reply Latest reply: Apr 24, 2015 2:19 PM by Clark Kipling RSS

    Ideal Model for Visualization Friendly

    Arturo Javier Torres

      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_REALNAMEDATE_STARTDATE_ENDID_LINK

      01       

      TASK 115/01/201531/01/201501
      02         TASK 215/01/2015   15/02/201502
      03TASK 301/02/201528/02/201503
      04TASK 401/05/201520/05/201504
      05TASK 501/03/201531/03/2015--
      06TASK 601/04/201515/04/2015--

      DATA PLAN:

      ID_PLANNAMEDATE_STARTDATE_END

      01       

      TASK 101/01/201531/01/2015
      02         TASK 201/01/2015   31/01/2015
      03TASK 301/02/201528/02/2015
      04TASK 401/02/201531/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

        • Re: Ideal Model for Visualization Friendly

          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;