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.
Please check the attachment for a sample.
Hope it helps.
Emp_aBS.qvw 152.5 K