Move the custom drill link to the end of the row.

[LookerExperts]

Knowledge Drop

Last tested: Feb 3, 2021
 

This is a great article to show how to do custom drills on a dimension or measure. But if you want to put the links at the end of the row in a table vis rather than associating it to a specific dimension, it's totally doable!

First of all, we need to create a new dimension for the link to "live" on. Example below:

dimension: links { sql: "link" ; }

Then we need to add the links on it. Bear in mind that we cannot use {{value}} here because this dimension doesn't have a meaningful value, but we could totally use {{ view_name.field_name._value }} to grab the value from a selected field on that row. Example below:

html: <a href="/looks/305?&f[users.state]={{ users.state._value }}">{{ value }}</a> ;;

Now you brought the links to the end of the table vis like below:

​

This content is subject to limited support.