Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Representing the data in graphs using custom formulas and logics in OTBI Dashboard.
Summary:
Representing the data in graphs using custom formulas and logics in OTBI Dashboard.
We have a requirement to create a graphs in OTBI using the Absence Balances, Absences Utilized and Assignment History.
Graph 1 Requirement (Leave Utilization): We need to show the percentages of Annual Leaves Utilized by all the employees in the department.
The formula to be used: (Leaves Utilized as of end date of month/ Leave balance as of starting of the year) *100
Note: If an employee doesn't have balance as of starting of the year and Hire Date after the Year selected in parameter, then we need to check his balance as of his enrollment start date.
Tagged:
0