View the original community article here
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.