Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Eligibility : A member who is Eligible for a Program
Enrolled: A member who is Enrolled in a Program.
For Eligibility i calculate the Gender Classification based on :
Dimension:
=If(MEM_GENDER='M','Male',IF(MEM_GENDER='F','Female','Unknown'))
Expression
= COUNT(DISTINCT PERSON_KEY)
For Enrolled i calculate the Gender Classification based on :
Dimension:
=If(ELIG_PERS_GENDR_CD='M','Male',IF(ELIG_PERS_GENDR_CD='F','Female','Unknown'))
Expression
= COUNT(DISTINCT ELIG_PERSON_KEY)
How can i bring these two dimensions under a single straight table as i have to calculate the Eligible/Enrolled percentage for
Gender group.There are two dimensions and two expressions which i have to get them under a single chart?
any ideas?
Hi,
Can you attach sample data and file?
Regards,
Jagan.
Hi Poornima
PFA.... Hope it will give you some idea
Regards
nirmal
Hi Nirmal,
The gender columns are also different in my case: MEM_GENDER,ELIG_PERS_GENDR_CD
How will i specify as two dimensions and which one to map for the expressions?
Hi,
It will depend on the way the data model is designed.
One thing need to know why do we have 2 different columns for Gender? Why cant we just combine it.
If we combine this, you will get the solution.
Regards,
Kaushik Solanki
can you please attach your application... hope it will easy to do
Both gender field names are different ok but in that field values are same correct???
They are two different tables .So
they are not linked in any way
ok attach your sample application
Hi,
Then you need to link them together anyhow to make them available under one chart.
Regards,
Kaushik Solanki
PFA sample application