Custom report and calculated columns

0

Hi,

I'm working on preparing a report based on my process. It's something similar to task manager. I can create a task with field responsible person nad some dates (deadline and end of task).

I;m makieng report, where I want to show all responsible people who have tasks divided on Active task, Active task after deadline, Finished task in time and Finished task after deadline.
I've made calculated column:
case
when WFD_AttDateTime5 < WFD_AttDateTime6 then 'YELLOW'
when WFD_AttDateTime5 > WFD_AttDateTime6 then 'GREY'
when WFD_IsFinish = 0 and WFD_AttDateTime5 < GetDate() then 'RED'
when WFD_IsFinish = 0 and WFD_AttDateTime5 > GetDate() then 'GREEN'
end

And in report I made grouping by this calculated column. The issue is that I have one series and all of it is in one color.
I wanted to add next series with different colors, but it will calculate the same numbers.

Addidiontal qeustion:
I can choose type of draw horizontal, but instead of people responsible by names I have numbers form 0 to number of all people.

Regards,
Adam