Knowledge Drop

Can I have multiple drill sets or drill options?


Last tested: Jul 21, 2020
 

This is a bit of a workaround. Sometimes we will want to have multiple drill choices available, but the "drill_fields" parameter only accepts one set. We can get around this by creating multiple hidden fields with different drill_fields and leveraging the {{ field._link }} parameter. This will have the "drill sets" as different links on the measure, which will pull up the individual drills when selected.

Example:

measure: count_with_drills {

type: count

link: {

label: "set 1 link"

url: "{{ count_set_1._link }}"

}

link: {

label: "set 2 link"

url: "{{ count_set_2._link }}"

}

}

measure: count_set_1 {

type: count

drill_fields: [id, ret]

hidden: yes

}

measure: count_set_2 {

type: count

drill_fields: [id, order_id]

hidden: yes

}

 

Note: if the field is long/complicated, you can also create a total dummy field like this:

measure: dummy {

drill_fields: [id]

hidden:yes

sql: 1=1 ;;

}

 

 

This content is subject to limited support.                

 

 

 


0 replies

Be the first to reply!

Reply