0 Replies Latest reply: Oct 31, 2013 7:55 AM by Kristina Vodich RSS

    Employee visit chart

      Hi all,

      I have a real trouble with this chart, hope somebody can help me


      I need to show the presence of employees at work as a two-coloured bar where one colour is the worktime and the other is permanent absence time. In the organization we have 4 types of work statuses(Present, Absent , Delay and Permanent absence) and a number of additional statuses for the status "Permanent absence" - e.g. Dinner, Business trip...


      The next status starts at the same time when the previous ends, so I have 2 fields for each status - Starttime and Endtime


      The best solution I've found is to make a Gant chart. But it works only for different phases and if I have 2 statuses of presence each day(before and after dinner) - I can't see the dinner time. For better diversification I've concatenated the status with the previous status


      Another problem is that I have a status "Absent" which starts at one day and stops onle the next day, so this chart works absolutely incorrect

      Here's the example


      Hope, you've catched the idea and thanks in advance for any help...