REPLACE Characters in string filters
Knowledge DropLast tested: Jul 30, 2019 If you see odd results in a drill's filter string, it may be that the ...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
How do I Referencing a Dimension from Another View in Drill Fields?
Knowledge DropLast Tested: May 13, 2020You can use the view_name.field_name syntax to reference a field from a...
Why do I have more rows in my drill table than my count_distinct measure indicates?
Knowledge DropLast Tested: March 15, 2021If multiple rows have the same value in the column which is being agg...
Default Explore/Drill Sort (Order By) Behavior
Knowledge DropLast Tested: March 15, 2021In the explore and drill menus, Looker chooses a default field to sor...
Can I control the row limit for drill-down overlays?
Knowledge DropLast tested: Jun 7, 2017 Yeah, there is an awesome way to get this working in the drill modal: m...
Why are my explore filters not getting added when I drill down on a measure?
Knowledge DropLast tested: Sep 15, 2019 It is most likely because the measure may have filter defined, i.e it ...
Move the custom drill link to the end of the row.
Knowledge DropLast tested: Feb 3, 2021 This is a great article to show how to do custom drills on a dimension ...
Why are my drills on running_total showing only that row?
Knowledge DropLast tested: Aug 6, 2020 running_totals are post-generated after the query is run, and so when w...
How to apply a filter or a sort to a drill-down field?
Knowledge DropLast tested: May 13, 2020 If we want to drill down on a specific field, but apply an additional ...
Logic behind "drill_fields" that gets auto-generated when we "create view from table"
Knowledge DropLast tested: Jul 2, 2019 When a view file is generated by "create view from table", measures(cou...
How do I preserve drill behavior when using HTML on a field?
Knowledge DropLast Tested: May 13, 2020You can use the {{link}} and {{linked_value}} liquid variable. This wil...
Can I drill down on a drill down?
Knowledge DropLast tested: March 2021Yep! As long as the fields have drill_fields defined, you can continue dr...
Why do I see "no results" when drilling from a measure?
Knowledge DropLast tested: May 14, 2020 When I drill into a measure, such as a count, I see what is filtered o...
Why are there dashboard links in my drill menu when I haven't defined any?
Knowledge DropLast tested: Jan 22, 2019Double check to see if you have the Labs feature Dashboards in Drill Me...
Preserving drill fields when conditional formatting is applied
Knowledge DropLast tested: Jan 21, 2019 Tip: Use the tag instead of your or tagWhen applying conditional form...
Why can I drill even though I don't have the see_drill_overlay permission?
Knowledge DropLast tested: May 29, 2019 Within Looker, the see_drill_overlay permission is included in the exp...
