Forum Discussion
S31573
Feb 08, 2021Copper Contributor
Formula for Distinct Count with Multiple Criteria
I found a formula that helps me do a distinct count =SUMPRODUCT((Data!$A:$A<>"")/COUNTIF(Data!$A:$A,Data!$A:$A&"")) However, now I need this to contain 2 criteria. I have similar formula but this ...
peiyezhu
Mar 03, 2023Bronze Contributor
how about sql?
select Date,Encounter,count(distinct(`unique id`)) cnt,group_concat(distinct(`unique id`)) from basic_to_two_dim_count_distinct group by Date,Encounter;
cli_create_two_dim~basic_to_two_dim_count_distinct~Encounter~unique id~count(distinct(`unique id`));
select * from basic_to_two_dim_count_distinct_two_dim order by Date COLLATE NATURAL_CMP;