Author: Won Park @wonkyoung_park
The Help Center article More Powerful Data Drilling provides a detailed overview of how to create custom drills using liquid variables. The Visual Drilling section outlines how to provide users with a visual drilling experience (other than the default data table) by using Looker’s visualization settings in a URL.
This article provides supplemental instructions for how to obtain those visualization settings and apply them to a drill field in LookML.
drill_fields
parameter within the definition of the field, and specify the fields to be included in the drill visualization.Copy the part of the escaped output after `&vis={`
and before `}&filter_config=`
"[this is where you enter the vis config details]"
: with the escaped string from step 9: link: {
label: "Show as line plot" #or your label of choice
url: "
{% assign vis_config = '{
[this is where you enter the vis config details]
}' %}
{{ link }}&vis_config={{ vis_config | encode_uri }}&toggle=dat,pik,vis&limit=5000"
}