用户如何使用逻辑(AND/OR)来过滤 tableau 中的仪表板? [英] How can a user use logic (AND/OR) to filter a dashboard in tableau?

问题描述

我的客户正在寻找一种基于逻辑过滤仪表板的方法.我们销售 20 多种产品，我们希望能够找到购买了产品 A 和/或产品 B 但没有购买产品 C 的客户.我的数据如下所示:

My client is looking for a way to filter a dashboard based on logic. We have 20+ products we sell and we want to be able to find customers that have purchased product A AND/OR Product B but not Product C. My data looks like this:

ID  |Beer   |Soda   |Chips
--------------------------
123 |0      |0      |1
234 |0      |1      |0
345 |0      |1      |1
456 |1      |1      |1

假设我的客户想要显示有多少客户购买了(苏打水或薯片)而不是啤酒.在上面的数据中，将显示 3 个结果.当然，他们希望所有可能的情况，而不仅仅是这个.这只是一个例子.

So let's say that my client wants to show how many customers purchased (Soda OR Chips) AND not beer. In the data above, 3 results would show. Of course they would want ALL scenarios possible, not JUST this one. This is only an example.

推荐答案

像这样透视数据并在过滤器架上使用 Product.Tableau 最适合处理高数据，而不是宽数据.

Pivot your data like this and use Product on the filter shelf. Tableau works best with tall data, not wide.

这篇关于用户如何使用逻辑(AND/OR)来过滤 tableau 中的仪表板?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！