如何在Google Data Studio中过滤CSV(逗号分隔的值)? [英] How to Filter CSV (Comma-separated values) in Google Data Studio?

问题描述

我目前正在构建一个仪表板，我希望有一种方法，使用户可以完全不必编辑仪表板就可以进行过滤.我有一个与此类似的数据集:

 对象标签示例1狗，猫，宠物示例2宠物，鸟示例3鸟，家庭装饰 

我想在Google Data Studio中有一个表，其中显示这些详细信息，然后是一个过滤器，您可以在其中键入任何文本，它将仅按文本包含在标签"中的记录进行过滤.

例如，我可以输入"bird"，然后表中仅显示"Example 2"和"Example 3"的记录.

这当前可行吗?

解决方案

可以实现的一种方法是使用最近发布的

2)CSV过滤器控件(位置)

• 通过单击社区可视化和组件按钮并将组件添加到报告中，然后选择该组件并将其放置在报告中.
• GIF演示#2:

3)CSV过滤器控件(用法)

• 要过滤的列 :标签
• 互动 :(勾号)应用过滤器
• 查看模式 :单选或多选所需值

I'm currently building a dashboard and I was hoping to have a way that users could filter without having to edit the dashboard at all. I have a Data set similar to this:

Object      Tags
Example 1   dog, cat, pets
Example 2   pets, bird
Example 3   bird, home decor

I want to have a table in Google Data Studio that shows these details then additionally a filter where you can type in any text and it will filter by only records where your text is contained in "Tags".

For example, I could type in "bird" and then only the records for "Example 2" and "Example 3" would show in the table.

Is this currently possible?

解决方案

One way it could be achieved is by using the recently released CSV Filter Control Community Visualization:

1) Community Visualisation Access

• At the Data Source, ensure that Community Visualisation Access is turned On.
• GIF to elaborate on #1:

2) CSV Filter Control (Location)

• Add the component to the Report by clicking on the Community Visualisations and Components button and selecting the component and placing it on the Report.
• GIF to demonstrate #2:

3) CSV Filter Control (Usage)

• Column to Filter on: Tags
• Interactions: (Tick) Apply filter
• View Mode: Single-select or Multi-select the required values
• Google Data Studio Report and GIF to visualise #3:

这篇关于如何在Google Data Studio中过滤CSV(逗号分隔的值)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！