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

[#1]

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)

Any suggestion?

[#2]

Hi,

Perhaps, you can try this:

Create a straight table/pivot table and add the expression for Absent hours, expand it and add something like the following as background color.

=if(sum(Abs_WeekHrs)>0,LightRed(),Green())

Please check the attachment for a sample.

Hope it helps.

Regards,

-Khaled