1 2 Previous Next 18 Replies Latest reply on May 17, 2013 2:49 AM by kettan

    Create a date to filter vacation calendar

    Egor Larin

      Hi there,

       

      I've got data with employee vacations.

       

       

      IDNamenumber of daysStart dateEnd date
      1man11413.05.201326.05.2013
      2man21407.03.201321.03.2013
      3man3127.03.201327.03.2013
      3man31413.05.201326.05.2013
      4man41424.12.201310.01.2013
      5man5
      19.07.201228.10.2013

       

      I need to change the size of the gantt chart by date. But if i will filter on Start Date by This year (2013) i dont see a man who took a vacation in 2012.

      If i will filtering by End Date by This year - i will not see the man who will take a vacation in 2013 and end date in 2014

      I know how to do it by changing my data - create a custom timeline in excel and write for each man his "own day-by-day line"

       

      IDNamevacation date
      1man113.05.2013
      1man114.05.2013
      1man115.05.2013
      1man116.05.2013
      1man117.05.2013
      1man118.05.2013...

      But it is "hard way". May be Tableu has got some tricks with data))

       

      I need to see current information for Today of my staff, see realtime vacation bar. If i will choose the date by This Month - i must see ALL the people who are out of office and it doesn't matter when their vacation start or end

       

      Pls, help)

       

      Thx

        1 2 Previous Next