Spotfire可视化-在运行总计中获得空白值吗？ [英] Spotfire visualization - Over in a running total gets blank values?

问题描述

我已经使用Spotfire构建了条形图可视化效果，其中包括使用Over函数来给出运行总计。月在X轴上，计数在Y轴上。
我的数据集包含没有值的月份。当我绘制图形时，尽管该月添加了零，但运行总计仍应包含一个值，但没有柱线。

I have built a bar chart visualization with Spotfire that includes the use of the Over function to give a running total. Months are on the X axis and counts are on the Y axis. My data set contains months where there were no values. When I graph that there is no bar although a running total should still contain a value although zero was added for that month.

如何获得一个没有价值的月份仍显示该月的柱线？

How do I get a month with no value to still show a bar for that month?

推荐答案

因为我看到了这个老话题，但最初没有找到解决方案，所以它是：

since I saw this old topic and didn´t find a solution at first, there it is:

公式很好，但显示条形图本身可以选择没有值的月份。

the formula is good, but displaying the months with no values is an option of the bar chart itself.

转到条形图 属性，然后选择 外观，然后在窗口底部：勾选补偿缺失值框。

Go to the bar chart "Properties", then "Appearance", then at the bottom of the window: tick the box "Compensate for missing values".

希望这将阻止以后的用户搜索：）

Hope this will prevent next users from searching in the future :)

这篇关于Spotfire可视化-在运行总计中获得空白值吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！