1 Reply Latest reply on Feb 5, 2019 12:06 AM by Norbert Maijoor

    Creating annual expected vacation plan

    Abdullah Almansour

      Hello,

      I'm stuck on building a schedule to identify the expected employee vacations for this year.

      I have start date and end date for each employee. However I couldn't figure out how to do it.

       

      any idea ?

       

      thx

        • 1. Re: Creating annual expected vacation plan
          Norbert Maijoor

          Hi Abdullah,

           

          Find my approach as reference below and stored in attached workbook version 10.5 located in the original thread.

           

           

          1. Pivot your dataset

           

          piviot.jpg

           

          2. D1. Enddate calc: {fixed [Employee]:min(if [Pivot Field Names]='Enddate' then [Pivot Field Values] end)}

           

          3. D2. Startdate calc: {fixed [Employee]:min(if [Pivot Field Names]='Startdate' then [Pivot Field Values] end)}

           

          4. M1. Duration: (datediff('day',[D2. Startdate calc ],[D1. Enddate calc]))

           

          5. Drag the required objects to the indicated locations

           

          dragit3.jpg

           

          Hope it helps,

           

          Regards,

          Norbert