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

Representing the data in graphs using custom formulas and logics in OTBI Dashboard.

Closed
12
Views
0
Comments
edited Aug 22, 2023 10:33AM in Reporting and Analytics for HCM

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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