Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Count Distinct by Two Attributes
Summary
I am not able to get distinct count by management level and genderContent
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!
1