隐式反馈数据集的协作过滤_过滤Google表格数据，而无需更改协作者看到的内容...

隐式反馈数据集的协作过滤

Filters in Google Sheets let you analyze data in your document by showing only the things you want. However, it changes how others see the document, too. Here’s how to use filter views to leave each collaborator’s view unchanged.

Google表格中的过滤器可让您仅显示所需内容，从而分析文档中的数据。 但是，它也改变了其他人如何看文档。 这是使用过滤器视图使每个协作者的视图保持不变的方法。

Fire up Google Sheets and open up a spreadsheet to get started.

启动Google表格并打开电子表格以开始使用。

Click Data > Filter Views > Create New Filter View.

单击数据>过滤器视图>创建新的过滤器视图。

The row numbers and column letters will turn a dark gray color when activated. At this time, you should give your filter view a name to distinguish it from any other views you make in the future and check the range is correct. You can always edit both of these later if needed.

激活后，行号和列字母将变为深灰色。 目前，您应该为过滤器视图命名，以使其与将来的其他视图区分开来，并检查范围是否正确。 如果需要，您以后可以随时编辑它们。

For this guide, we want to filter anything in the table that has a price per unit greater than $10. Click the filter icon in the field for “Price Per Unit.”

对于本指南，我们希望过滤表中价格大于10美元的所有内容。 单击“单位价格”字段中的过滤器图标。

For this next part, you can choose to filter either by values or conditions to analyze your data. “Filter by Value” offers a simple way to see data and choose specific values in the column. “Filter by Condition” gives you a much more granular approach with the option to add custom formulas to find data.

在下一部分中，您可以选择按值或条件过滤以分析数据。 “按值过滤”提供了一种查看数据并在列中选择特定值的简单方法。 “按条件过滤”为您提供了更为细化的方法，可以选择添加自定义公式来查找数据。

First, click “Filter by Condition” to expand the section, click the dropdown box, and then click the “Greater Than” option.

首先，单击“按条件过滤”以展开部分，单击下拉框，然后单击“大于”选项。

Enter the conditions for the filter and click the “OK” button.

输入过滤条件，然后单击“确定”按钮。

Just like that, you can now see all products that cost more than $10 per unit without disrupting the view of any other contributors.

这样，您现在可以看到所有单价超过10美元的产品，而不会影响其他任何贡献者的视线。

Because you can toggle only one filter at a time, you can stack filters for each column to increase your data analyzing potential. All you have to do is click on another one of the filter icons and repeat the same process.

因为一次只能切换一个过滤器，所以可以为每列堆叠过滤器以增加数据分析的潜力。 您所要做的就是单击另一个过滤器图标，然后重复相同的过程。

To turn all the filter views off, click the “X” in the top-right corner of the sheet.

要关闭所有过滤器视图，请单击工作表右上角的“ X”。

Anytime you want to turn a filtered view back on, click Data > Filter Views and then choose a filter to view.

每当您想重新打开过滤视图时，请单击数据>过滤视图，然后选择要查看的过滤器。

One of the great things about filter views is the ability to show filtered data without altering other collaborators’ spreadsheet view. However, if anyone wants to use your filter views, they can—even people who have view-only access.

过滤器视图的一大优点是能够显示过滤后的数据而无需更改其他协作者的电子表格视图。 但是，如果任何人都想使用您的过滤器视图，他们甚至可以拥有仅查看权限的人。

Click Data > Filter Views, and then choose one of the custom views made by other collaborators.

单击数据>筛选视图，然后选择其他协作者创建的自定义视图之一。

Although this is a very basic use of a filtered view, there seems to be no limits to its use. You can stack multiple filters and even add custom formulas to analyze and sort your data without having to disrupt other people you’re working with.

尽管这是过滤视图的非常基本的用法，但似乎对其使用没有限制。 您可以堆叠多个过滤器，甚至可以添加自定义公式来对数据进行分析和排序，而不必打扰与您合作的其他人。

翻译自: https://www.howtogeek.com/442608/how-to-filter-google-sheets-data-without-changing-what-collaborators-see/

隐式反馈数据集的协作过滤