2 Replies Latest reply: Jul 15, 2016 8:32 PM by Ankit Luthra

# KPI to show % Female for a particular Quarter

Hello,

I have a data set like this:-

 Name Quarter Gender A Q2 Male B Q2 Male C Q2 Female D Q2 Male E Q4 Male F Q4 Female

And I am trying to show KPIs for # of Female as well as % Female for Q2, Q4 and total. Something like:-

KPI 1 : Total # Female = 6

KPI 2 : Total % Female = 33.33 %

KPI 3 : # Female for Q2 = 1

KPI 4 : % Female for Q2 = 25%

KPI 5 : # Female for Q4 = 1

KPI 6 : % Female for Q4 = 50%

Could anyone please suggest what expression to use for KPIs 1 thru 4 ? I guess I can edit 3 & 4 to get 5 & 6 (for Q4).

Thanks in anticipation!

Ankit L.

• ###### Re: KPI to show % Female for a particular Quarter

Maybe like

1)

=Count({<Gender = {'Female'}>} DISTINCT Name)

2)

=Count({<Gender = {'Female'}>} DISTINCT Name) / Count(DISTINCT Name)

3)

=Count({<Gender = {'Female'}, Quarter = {'Q2'}>} DISTINCT Name)

4)

=Count({<Gender = {'Female'}, Quarter = {'Q2'}>} DISTINCT Name) / Count({<Quarter = {'Q2'}>}DISTINCT Name)

• ###### Re: KPI to show % Female for a particular Quarter

Thanks a lot, Stefan. Worked great!

- Ankit