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