Count non-distinct values in a dimension

Hi,

How do I go about count non-distinct values in looker explore for one dimension.

I can write this in SQL but not sure how to translate that to the lookML model and explore.

select count(*)

from (

SELECT sample_id, count(*)

FROM

TABLE

WHERE

DATE(_PARTITIONTIME) = "2022-11-09"

group by 1

having count(sample_id) > 1)

I already have the basic explore setup, i can get the rows for where sample ID is greater than 1 but need to count the number rows on top of this to provide one value to display.

0 0 371
0 REPLIES 0
Top Labels in this Space
Top Solution Authors