Skip to Content
0
Dec 02, 2018 at 06:42 AM

Webi; Count Distinct variables in a column.

160 Views Last edit Dec 12, 2018 at 12:56 PM 2 rev

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