Spotfire中特定值的相邻单元格的计算列 [英] Calculated Column for Adjacent Cells of a Specific Value in Spotfire

问题描述

我想知道是否可以创建一个计算列来计算有多少个相同值（仅此值）的连续单元（即，彼此相邻），以便我可以将其除以总数该列中的单元格数。我一直在努力解决这个问题，对您的帮助或建议将不胜感激。这是我发布的上一个问题的更新（下面的链接）

I am wondering if it is possible to create a calculated column that will count how many cells of the same value (and only this value) are successive (i.e., next to each other) so that I can divide it by the total number of cells in that column. Any help or advice would be greatly appreciated as I've been scratching my head over this for a while. This is an update to a previous question I posted (link below)

此新问题的主要区别如下：
（1）我仅想计算与其他蓝色单元格
相邻的蓝色单元格的数量（2）我想针对每个站点（超过）进行此操作

上一个问题在这里： Spotfire中相同值的连续单元数

推荐答案

您将需要再次插入RowID列，但此后该公式将为您服务。您可以通过使SiteB的深度1 =蓝色来进行测试，以便在不同的站点中有两个蓝色触摸。

You'll need to insert your RowID column again, but after that this formula will work for you. You can test by making SiteB, Depth 1 = Blue so that you have two "Blues" touching that are in different sites.

If(([Color]="Blue") and 
(([Color]=First([Color]) over (Intersect([Site],Next([rid]))))
or
([Color]=First([Color]) over (Intersect([Site],Previous([rid]))))),1,0)

这篇关于Spotfire中特定值的相邻单元格的计算列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！