Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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