Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am now starting to build an HR dashboard for my company, and I would like to present a gender diversity ratio chart.
now I'm stuck with the expression, I tried to use a different expression but it didn't work for me.
Count(distinct {<GENDER = 'female'>}Employee_Code)
/
count(distinct {< GENDER = 'male'>}Employee_Code)
* 100
can you please help me
thank you in advance
@Nadiyah_Alotaibi The Formula Should be : Count(Female Employees)/ Count(Female+Male Employees).
So based on the Above your expression is as follows:
(Count(distinct {<GENDER = 'female'>}Employee_Code)/ Count(distinct Employee_Code))*100
First of all check your set expression syntax: {<GENDER={'female'}>}
If this still does not work, then answering these questions can help:
How is this KPI defined in your organization?
Can you describe how your result using this expression differs from what you would expect?
Can you please provide some sample data and your expected result?