Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Topics started by chadvanholland

1 Topic

C
chadvanhollandMember
asked in Dashboards & looks

Selecting Only Unique Records for a Total Count

I have a use case where I have duplicate records but difference dates and I want to get a count of Unique Records by only selecting the first recorded Record For example, Data Set: UID-Date-Value A 6/12 Registered A 6/12 Registered A 6/13 Registered B 6/14 Registered Want to Return: UID-Date-Value A 6/12 Registered B 6/14 Registered Count = 2 How can I do this in Looker?

4
C
4 years ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service