Dynamically Choose Selected Columns?

Hi there,

I have a Dashboard with a Table Visualization that is built selecting 3 columns/fields (select A, B C…).

My goal is for an end-user to select the columns they would like to see in the table visualization through the filters at the top. Ideally, there would be a filter called “Field Selector” where they can multi-select whichever columns they want (select X, Y, Z…).

Essentially, the SELECT statement in the query should be querying a List as opposed to individual fields, where the List would be the columns selected in the Field Selector filter.

SELECT List

List = (X,Y,Z)

FROM table

Is something like this possible in looker?

Yes, you can do this by building a dynamic dimension. Here is an article on how to do it.

1 Like