Multiple drill downs on filtered measures

[Anne-Caroline_R]

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! 

[emoxtom-1637169]

Hi

Are the customer_id and customer_name for drildown filtered as new_user?

[Anne-Caroline_R]

Hi emoxtom, 

Thank you for your reply, no they both are generic dimensions. The objective of using the “set” to create drill downs is to be able to use it for very different measures. 
 

In my example I only show it for for mrr_from_new_customers but I actually use the same drill sets for other measures such as mrr_from_all_customers, mrr_from_uk_customers etc.