on 12-02-2018 6:42 AM
I'm trying to create a variable that will tally the total number of unique variables in a column. For example, based on the below ICD10 codes, the variable would display Z02.9 (4), F32.9 (4), etc. I tried using =Count([Diagnosis Code];Distinct) but that only yields a tally of 1 for each row. Any help greatly appreciated. Thanks.
Z02.9
Z02.9
Z02.9
Z02.9
Z00.00
F32.9
F32.9
F32.9
F32.9
F43.10
F43.10
F43.10
G47.9
try this.
=Count([Diagnosis Code]) in ([Diagnosis Code])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Randy,
Can you please refer below blog?
https://blogs.sap.com/2015/09/22/how-to-get-unique-distinct-records-in-webi-reports/
-Kedar KaleYou must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.