将 Report Builder 图表拆分为两个图表区域以分散数据
我在 Report Builder 2.0 中有一个条形图，它沿 y 轴有很多值。我想拆分图表以显示两个图表区域，甚至有两个单独的图表，每个图表的 y 轴上只有一半的值。因此，图表 1 将具有 y 轴值 A、B、C 和 D，而图表 2 将具有 E、F、G 和 H。我想我可以在图表上添加一个过滤器，以便它只显示其中的行列值 < E（对于图表 1）且 ColumnValue >= E（对于图表 2）。那么我该如何编写这样的过滤器呢？它可能需要执行 Round(Count(ColumnValue) / 2) 来获取中间值的索引，但是我如何实际获取该值（例如 E）进行比较？
或者也许有一些内置的方法可以通过将图表分成两个单独的图表来分解长轴来美化图表。我不知道。建议？
I have a bar chart in Report Builder 2.0 that has a lot of values along the y-axis. I would like to split the chart to show two chart areas, or even have two separate charts, each with only half of the values on the y-axis. So chart 1 would have y-axis values A, B, C, and D, while chart 2 would have E, F, G, and H. I was thinking I could have a filter on the chart so that it only showed rows where ColumnValue < E (for chart 1) and ColumnValue >= E (for chart 2). How can I write such a filter, though? It'll probably need to do Round(Count(ColumnValue) / 2) to get the index of the middle value, but then how do I actually get what that value is (e.g., E) for comparison?
Or maybe there's some built-in way of prettifying a chart by splitting it into two separate charts to break up a long axis. I don't know. Suggestions?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
尝试使用来自同一源数据集的两个图表，并在第一个图表上启用过滤器，如下所示：
RunningValue(Fields!GroupFieldName.Value,CountDistinct) < ;= CountDistinct(Fields!GroupFieldName.Value) / 2- 第二个类似的公式，使用
<=替换为>。Try using two graphs from the same source dataset, with a filter on on the first graph like the following:
RunningValue(Fields!GroupFieldName.Value,CountDistinct) <= CountDistinct(Fields!GroupFieldName.Value) / 2- and a similar formula on the second, with
<=replaced by>.