0 Replies Latest reply: Apr 10, 2017 6:57 AM by Shivani Singhal RSS

    Doubt in making Deptt-wise Month-wise Trend.

    Shivani Singhal

      How can I make deptt-wise month-wise trend(header count trend).

      I have linked the Master Calendar with the following scripting. Please suggest me a way to generate the deptt-wise month-wise trend.

       

       

      SCRIPTING:

      fact:

      load * inline [

      EmpID,WefDate,Dept

      1,15/07/2016,HR

      1,01/01/2017,Admin

      2,25/09/2016,HR

      3,25/09/2016,Analytics Developer

      3,01/02/2017,Analytics Sales

      4,01/08/2016,Analytics Sales];

       

       

      details:

       

       

      load*,

      DATE(DOJ)&' - '&date(DOL) as Period;

      load * Inline [

      EmpID,DOJ,DOL

      1,15/07/2016,

      2,25/09/2016,31/12/2016

      3,25/09/2016,

      4,01/08/2016,

      ];

       

       

      Bridge:

       

       

      inner join IntervalMatch("WefDate",EmpID)

      Load distinct

      DOJ,

      DOL,EmpID Resident details;

       

       

      DROP TABLE details;