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...

      Kristina