Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

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
21
Views
2
Comments
MariaStanciu
MariaStanciu Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Forum

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 Mod

    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!