Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an admission data model with many tables.
When I calculate a KPI (in text Object)
=count(PK_ADMISSION) returns 17,564 which is correct PK_ADMISSION has one to many links in the data model
=count(DISTINCT PK_ADMISSION) im getting a value 35,747 which is correct
=count({1} DISTINCT PK_ADMISSION) returns 35,747
how do i Count Distinct value of a selected Field (Hospital) while ignore all other selections?
=count({1} DISTINCT PK_ADMISSION) should be correct
Would you mind sharing your app? Preparing examples for Upload - Reduction and Data Scrambling
=count({1} DISTINCT PK_ADMISSION) should be correct
Would you mind sharing your app? Preparing examples for Upload - Reduction and Data Scrambling
A "brute force" approach is creating an Alternate State and putting that text box in that state with =count(DISTINCT PK_ADMISSION) as expression
=count({1<[Hospital Desc] =$::[Hospital ]>} DISTINCT PK_ADMISSION)