Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to calculate percentage of Employees with more than 5 hours of learning? — Cloud Customer Connect
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

How to calculate percentage of Employees with more than 5 hours of learning?

Received Response
22
Views
1
Comments

Summary:

I need to get the percentage of Employees with more than 5 hours of learning for a specific time period in OTBI. So far, I have:

  • a counter for employee names to get the total number of employees
  • a calculated column that sums the total hours of actual effort per employee
  • a calculated column that evaluates to 1 if total actual effort is higher than 5 or 0 if less

Do you have any ideas? I tried to SUM the second calculated column "SUM(CASE WHEN SUM("Completion Information"."Total Actual Effort" BY "Assigned to Information"."Assignee Display Name")>5 THEN 1 ELSE 0 END)", but seems like the nested aggregation is a bit of a problem and fails to produce the correct result.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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