I want a drill down to my table

Looker Q&A Looker Studio
1

I have a table in my looker studio report that shows task title, status , due date etc. I also want to show the task description, but since the text can be huge, I want to show it as a drill down. What I mean is when I click on one of the rows of my table, it shows all the table fields including the description (possible as a pop out or some format which makes it easy to read huge text). What is the best way to solve this?

Priyanka1311_0-1738841315701.png
Priyanka1311_0-1738841315701.png473Ă—216 4.84 KB

1 Like
2

hi

Welcome to the Google Looker Help Community.

this drill-down effect for task descriptions in Looker Studio (formerly Data Studio) using a combination of techniques. Here’s a breakdown of the best approach and why it’s preferred over other options:

Recommended Approach: Using a Details Table with a Filter Control

Step-by-Step Example

  1. Data Source: Assume you have a data source with fields: Task Title, Status, Due Date, Description.

  2. Main Table: Create a table with Task Title, Status, Due Date.

  3. Details Table: Create another table with all fields: Task Title, Status, Due Date, Description.

  4. Filter Control: Add a filter control, select “Task Title” as the dimension. Crucially, connect this only to the Details Table.

  5. Main Table Link: In the main table’s properties, go to “Link,” choose “Filter Control,” and select the “Task Title” filter control. Now, clicking a row in the main table will filter the details table to show the corresponding task’s full information, including the long description.

Thank You.

Was it helpful? Click like.

3

Here’s a hack that may work for you.

Create a calculated field called “Hover for Detail” (or whatever you want the new field to be called) and use CONCAT and “\n” (new line character) to create a field that brings all your fields together. So for you it might look like this:

CONCAT(Title ,“\n\n”, Status," \n", Status Details, “\n”, Description)

Then add that calculated field to your table (if you create it at the source level, but you can also create it at the chart level) and under Table Body, turn on wrap text and turn off auto-height.

Basically, you’ll only see the first CONCAT item in your table (that’s why I use two \n after the first item), with none of the other items visible until you hover.

Not a perfect solution, but it does work.

1 Like
4

@ptrivedi If you’re going to use AI to generate responses, please include a note that the response was auto-generated. Although I guess if you’re an AI bot, you won’t see my message :slightly_smiling_face:

1 Like
5

yes AI to generate responses

i next time not use

6

Thanks, its a nice hack but readability is a problem. That is why I want a popup to show the description. So far I haven’t found a cleaner way to do it