You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTBI Color coding on rows

edited May 16, 2023 11:43AM in Reporting and Analytics for HCM 5 comments

Summary:

Hi Team,

Can anyone please help us on achieving the below requirement in OTBI.

We have the percentages on each of the Job row as shown.

These percentages are the count(Absence Days for a particular week)/Total number of persons in that Job.

We want these percentages to appear in different color.

Less than 33% no color

Equal to 33% Light yellow

Greater than 33% Red 

Ex: Considering 100% on 13-Mar-23. There could be 2 employees on that job and 2 of them were on leave. so 2/2 =1 *100 = 100%

Similarly we have for 17-Apr-23. One employee was on leave 1/2*100 =50%

The below percentages must appear in different color.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!