Skip to main content

Hi there,

 

I've got data with employee vacations.

 

IDNamenumber of daysStart dateEnd date1man11413.05.201326.05.20132man21407.03.201321.03.20133man3127.03.201327.03.20133man31413.05.201326.05.20134man41424.12.201310.01.20135man5

 

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 date1man113.05.20131man114.05.20131man115.05.20131man116.05.20131man117.05.20131man118.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

27 answers
0/9000