Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

HCM - Calculate average number of goals per employee

Received Response
11
Views
2
Comments
MariaStanciu
MariaStanciu Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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!

Tagged:

Answers

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics & AI Lead

    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.

  • RVohra
    RVohra Rank 6 - Analytics & AI Lead

    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!