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!
Hello, I'm trying my hand at creating some KPI's and Dashboard Visualizations for the Recruiting Activity Center (RAC) per the following documentation: Flexible Reporting in Redwood Dashboards Redwood Experience: Recruiting Dashboard When I add a session variable to my OTBI reports, I correctly see a value of 0 in my…
'Facility Name' exists in the Recruiting - Recruiting Real Time multiple times with varying usage. Job Requistion -> Job Requisition - Additional Details -> Facility Name Job Requistion -> Location -> Facility Name Is there any reason why these two Facility Names would not exist in the Recruiting - Real Time Events subject…
we have a requirement to fetch Worker Historic information like Current Job Title Previous Job Title Previous Department New Department Previous Manager New Manager Previous Location New Location which subject area stores this information in the OTBI?
Could you please provide an update on when the 26C Deprecated BI View Objects document will be available? As Oracle Cloud 26C is scheduled to roll out soon, with test environments expected to be updated on August 7, followed by the production release on August 21, we have a limited window to review and assess any potential…
Hi team, I would like to add the work order notes to my work order schedule calendar, but I'm unable to find where these notes are stored and what otbi subject to use to access them. Be great if I can be pointed in the right direction, thanks
