1 Reply Latest reply: Jan 22, 2013 8:32 AM by Syed Khaled Shahbaaz RSS

    How to make a coloured monthchart/pivot for absence from work

    Göran Hofstedt

      Hi

      A time ago I came across a picture that shows a chart with abcence from work in a PA-app in qv. I have now been trying to do the same but don´t succed. I have uniq personID and hours of absence. Also start and stop date for the absence.

       

      Can someone help me, or maybe someone have a demo with something similar. I guess it also can be used to show days a frontend-support are most busy, or when there are most customers bying stuff and so on. But I can´t find any demo, maybe i don´t know what terms I should search for.

       

      The chart use dimensions YearMonth and on the top it´s Day of the month, in the colured coulmns it´s the dayname that are shown (swedish in this pic)

       

      absence.JPG

      Any suggestion?