Question

count does not count distinct primary key

  • 14 March 2023
  • 0 replies
  • 14 views

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 replies

Be the first to reply!

Reply