Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Counts by the top subset of data

  • 13 September 2016
  • 1 reply
  • 90 views
srivera

I’m looking to build out the top 10 counties in each state. So basically, I need to count each transaction in each state & county combination. The select the top 10 counties for each state.


Is there a pattern or method to do this using lookml ? Maybe using PDTs?


Thanks in advance.

1 reply

Zam
Userlevel 4
Badge

@srivera - We’d recommend ranking your dimensions in a derived table and then filtering on rank. There is a great discourse on doing so here

Reply


Terms of Service