count does not count distinct primary key

stergios99
Participant II

Hi,

from looker documentation "type: count measures do not support the sql parameter, as a type: count measure performs table counts based on the table's primary key”

however if i create a compounded key, looker does not count based on it.

i need to write

measure: count_distinct

sql: prim_key_dimension

shouldnt it work with just "”measure:count"” ?

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