Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Create average assignment count in oac
Lauriane Massin Whitaker
Rank 6 - Analytics & AI Lead
Hi,
How can I create a report showing the average assignment count for 1 specific year (2024 - from jan to dec) based on worker category and gender ? I would have the gender in columns, the worker catégories in lines and the average ass count as values.
Thank you
0
Answers
-
You should be able to create a report like this using the HCM Subject Areas as documented here:
Which part is the sticking point?
Regards,
John
0 -
Hi John,
Here is the report using "Assignment count" : all good.
Here is the report using "AVG Assignment Count" :
I don't understand why… I want to have the average ass count from january to december (the whole 2024 year), based on what I have as attributes : Worker categories and Gender.
Any suggestion please ?
Regards,
Lauriane
0
