Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Thanks a lot, Stefan. Worked great!
- Ankit