Group by Ethnicity and Headcount in Analysis
Summary: Issue in Analysis when count of ethnicty is added in Case statement
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.
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.