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

Group by Ethnicity and Headcount in Analysis

Question
1
Views
0
Comments

Summary: Issue in Analysis when count of ethnicty is added in Case statement

Hi Team,

I have taken the Employee Ethnicity Analysis from Line Manager Dashboard from the delivered Human Capital Management path. The Analysis will give result as number of employee (in Percentage) in each Ethnicity in a Horizontal Bar Graph.

Content (required):

My requirement is to group few Ethnicity types into single bar in the graph. Say for example i need to group 'Asian' and 'Chinese' to be grouped under Asian and the bar will have the total percentage of both Ethnicity. The other Ethnicity's should come as it is like Native American, Hispanic/Latino each in separate horizontal bar in the graph. For the above conditions I used Case statement in Edit formula of the column.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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