I have a bigquery dataset containing leads (names, email addresses, a ton of info gleaned from different sources). I have a looker studio dashboard that shows rows from this datasets, sorted by a score column. It works well but I want it to be that when you click on one of the rows in this table, you get a "long form" view of all the info associated with this record. Due to the large number of fields, this would need to be displayed vertically; something like this (from airtable):

This would be displayed when you click on a row in the summary table.

Is there any way I can set up something like this in Looker Studio? I am trying to use looker studio for this because all my other dashboards are in looker studio.

I have a bigquery dataset containing leads (names, email addresses, a ton of info gleaned from different sources). I have a looker studio dashboard that shows rows from this datasets, sorted by a score column. It works well but I want it to be that when you click on one of the rows in this table, you get a "long form" view of all the info associated with this record. Due to the large number of fields, this would need to be displayed vertically; something like this (from airtable):

This would be displayed when you click on a row in the summary table.

Is there any way I can set up something like this in Looker Studio? I am trying to use looker studio for this because all my other dashboards are in looker studio.

• google-bigquery
• looker-studio

3 Answers 3

A simple idea would be to have a second vertical table limited to one record, which displays all the fields you want to show. The main drawback is it won't disappear when no record is selected (it will display the top one). For what it's worth, I searched briefly for other options, but only found the same suggestion.

I made an example here with the dataset here.

You can format your data using a community visualization named Templated Record that supports HTML.

1. Create a table with your leads.

2. In the table's chart setup enable "Cross filtering".

3. Click on "Community visualizations and components".

4. Go to "+ Explore more".

5. Look for "Template Record", allow it and add it to your report.

6. Add all dimensions you want to display in your long form view.

7. In the templated record settings, go to the STYLE TAB.

8. Use HTML to desing your latyout.

9. Use {{dimension}} syntax to insert field values.

Here is how it works and an example of the results.