Hello,
What would be the best way to Calculate average number of assigned performance goals per employee with breakdown per department?
Formula needed is = Total count of goals / Total count of employees (per department)
Thank you!
To calculate the average number of assigned performance goals per employee by department in OTBI Fusion Cloud, use a custom measure with a division of two distinct counts: total goals and total employees, grouped by department.
If I remember correctly, Performance Goal Details Real Time can be used and if you can create a calculated measure for average goals per employee
COUNT("Goal"."Goal Identifier") / COUNT(DISTINCT "Worker"."Person Number")
Hope it helps!
