Group by Ethnicity and Headcount in Analysis

Darius Sunder

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.

In similar way there should be a bar in the graph which will show the percentage of employees who have selected more than one ethnicity. For this I used count condition in the same case statement but I am facing issue in the output result. But when the more than ethnicity condition is removed the Analysis results correctly with the above conditions(1st para).

So i request you to kindly help me on this if any other way is there to achieve all the conditions handled and the graph will have percentage of employees of all ethnicity conditions.

Thanks in advance.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):