Knowledge Drop

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

  • 8 July 2021
  • 0 replies
  • 142 views

Userlevel 4

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.                

 

 


0 replies

Be the first to reply!

Reply