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.