gender diversty ratio

[Nadiyah_Alotaibi]

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 

[sidhiq91]

@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

[MarcoWedel]

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?