Can I control the row limit for drill-down overlays?

[LookerExperts]

Knowledge Drop

Last tested: Jun 7, 2017
 

Yeah, there is an awesome way to get this working in the drill modal:

measure: return_rate {

type: number

value_format_name: percent_2

sql: 1.0 * ${returned_count} / nullif(${count},0) ;;

link: {label: "Explore Top 20 Results" url: "{{ returned_count._link}}&limit=20" }

}

measure: returned_count {

type: count_distinct

sql: ${id} ;;

filters: {

field: is_returned

value: "yes"

}

drill_fields: [detail*]

}

You can see more examples on our article of custom data drilling on this article: More powerful data drilling.

This content is subject to limited support.