Multiple drill downs on filtered measures

Hi everyone, 

I have been using the link parameter to create multiple drill downs options for my dimensions and measures for quite some time now, following this methodology: https://datatonic.com/insights/looker-drill-downs/

However, I uncovered a flaw in this process for filtered measures: the filter parameters of the measure are not taken into account in the drill downs. 

A quick example: 

set: detail_per_orga {
fields: [customer_id, customer_name, new_mrr]
}
set: cs_data {
fields: [customer_id, cs_owner, market, mrr]
}

measure: drill_downs_details { ## dummy measure used to pass the drill downs
label: "Drill downs for details"
description: "used for drill downs only"
hidden: yes
sql: 0 ;;
drill_fields: [detail_per_orga*]
}

measure: drill_downs_cs { ## dummy measure used to pass the drill downs
label: "Drill downs for CS team"
description: "used for drill downs only"
hidden: yes
sql: 0 ;;
drill_fields: [cs_data*]
}

measure: mrr_from_new_customers {
hidden: no
label: "MRR from new customers"
type: sum
sql: ${mrr} ;;
filters: [new_customers: "yes"]
link: { label:"Customer details" url:"{{drill_downs_details._link}}" }
link: { label:"CS details" url:"{{drill_downs_cs._link}}" }
}

Here, when I drill into the measure mrr_from_new_customers in my reports , I expect to see only the details for new customers (as my measure is filtered on new_customers: “yes”), however, the drill downs actually display the whole customer dataset. 

How can I fix this to make sure my drill options display the right data? 

Many thanks! 

7 2 491
2 REPLIES 2
Top Labels in this Space
Top Solution Authors