Oracle Transactional Business Intelligence

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

OTBI: How to categorize Front Loaded Accrual Balance and get the employee Headcount

Question
8
Views
0
Comments

I have a requirement to get Headcount of the employees based on Annual Leave Accrual Balance where it should be categorized like 0-5 and 6-10 and 11-15 and 16-20 and >20. Like how many employees have the accrual balance between 0 to 5 and how many employees have the accrual balance between 6 to 10 and how many employees have the accrual balance between 11 to 15 and how many employees have the accrual balance between 16 to 20 and how many employees have the accrual balance >20.

I have used Workforce Management - Accrual Real Time subject area → Employee Plan Participation → Front-Loaded Plan → Accrual Balance measure column to get accrual balance.

I have used case statement to get the category.

But I am unable to get count of the employees based on the category column, because it is a measure column.

Could you please help me to get the employee count based on the given category.