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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Count Distinct by Two Attributes

edited Mar 30, 2021 7:54PM in Reporting and Analytics for HCM 3 comments

Summary

I am not able to get distinct count by management level and gender

Content

Hello - I'm creating a simple analysis to count the number of employees by a grouped management level and gender.

For the measure, I've used:

SUM(COUNT(DISTINCT "Worker"."Person Number") by "Job"."Job Manager Level")

However, this returns the count only at the Manager Level and disregards the gender. Is there an approach to get the measure to be counted at both the Manager Level and Gender. I also tried using Head Count as the measure but I run into the same issue i.e. the number out displayed is not grouped both manager level and gender. I've attached the catalog file for reference. Many thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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