Spotfire-在堆叠的条形图中显示最高值 [英] Spotfire - Show top values in stacked bar chart

问题描述

我有一个堆积的条形图，看起来像这样:

I have a stacked bar chart that looks like this :

我只想显示价值的前3个小节，即前三个小节.我尝试使用显示/隐藏"功能，但无法正常使用.

I would like to only show the top 3 bars in terms of value, that is to say the three first bars. I tried to use the Show/Hide feature but it doesn't work as I expected.

例如，如果我将显示/隐藏"值限制为显示前1个"值，则得到:

For example if I limit to Show top 1 value with the Show/Hide value, i get :

当我希望第一张照片中也堆叠有橙色和蓝色条形图时.

when I expect to also have the orange and blue bars that are stacked in the first picture.

有什么方法可以做我想要的吗?

Is there a way to do what I am looking for?

推荐答案

我找到了一种更好的方法:

I found a better way to do this :

使用可视化属性的显示/隐藏"规则，您必须添加此规则

Using the Show/Hide rules of the properties of the visualization, you have to add this rule

DenseRank(Sum([Value]) over (All([Axis.Color])),"desc") <= 3

然后，您必须在值输入中 [Axis.Value] .

Then you have to [Axis.Value] in the value input.

3 是条形图中要包含的条形数量.

3 is the number of bars to have in the bar chart.

[Value] 是Y轴的列，在我的情况下，我使用Count()因为我的Y轴是(Row Count).

[Value] is the column of the Y Axis, in my case I used Count() because my Y axis is (Row Count).

您可以在此链接中找到更多信息: https://community.tibco.com/questions/question-showhide-top-10

You can find more info at this link : https://community.tibco.com/questions/question-showhide-top-10

这篇关于Spotfire-在堆叠的条形图中显示最高值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！