Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI: How to categorize Front Loaded Accrual Balance and get the employee Headcount

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.