admin管理员组

文章数量:1414908

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
Share Improve this question asked Feb 23 at 13:08 Alex FlintAlex Flint 6,78711 gold badges49 silver badges86 bronze badges
Add a comment  | 

3 Answers 3

Reset to default 2

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.

本文标签： google bigqueryLong form record view in looker studioStack Overflow

版权声明：本文标题：google bigquery - Long form record view in looker studio - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1745154173a2645067.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。