Reporting-Services – How to add moving average to Report Builder 2.0 chart

This is driving me crazy. I have looked at all relevant MSDN tutorials, but they discussed how the “data field drag and drop area” and “add calculation series” menu option should exist but not , And did not provide a screenshot to show the’data field drop zone’ is. This is the menu I get when I “right click on the field in the data field drop zone”:

It’s frustrating The thing is that I know that I have seen this calculated series content before, but I can’t find it anymore, it is not in the’series properties’ dialog that I can see, and I can’t find a tutorial on how to find this function. I guess you can only have one calculation series on certain chart types, or I haven’t opened some signs or other things, but I haven’t seen any mention of it.

Can you tell me how to Does Report Builder 2.0 add a row of graphs showing the median of my data? I think I can do this by adding a’moving average’ through the’calculated series’, but I can’t find how to add it.

Edit: On another chart, “add a calculated series” Menu options are available. This is a stacked column chart, and the series I right-clicked is an expression using RunningValue.

< div class="answer"> I have to delete the series group (from the’data field placement area’ on the right side of the chart) so that all I have are 1) category group (bottom of chart) and 2) data series (top) chart ). Then I can right-click on the data series at the top of the chart, “Add Calculated Series” is a menu option.

This is driving me crazy. I have looked at all relevant MSDN tutorials, But they discussed how the “Data Field Drag and Drop Area” and “Add Calculation Series” menu option should exist but it is not, and no screenshots are provided to show that the “Data Field Drag and Drop Area” is. This is my “right-click on the data field” The menu you get when you place the field in the area”: ​​

The frustrating thing is that I know that I have seen the content of this calculated series before, but I can’t find it anymore, it Not in the’Series Properties’ dialog that I can see, I can’t find a tutorial how to find this feature. I guess you can only have a calculated series on certain chart types, or I didn’t turn on some logos or other things, But I haven’t seen any mention of it.

Can you tell me how to add a row of graphs showing the median of my data in Report Builder 2.0? I think I can do this by adding a’moving average’ through the’calculated series’, but I can’t find how to add it.

Edit: On another chart, “add a calculated series” Menu options are available. This is a stacked column chart, and the series I right-clicked is an expression using RunningValue.

I had to delete the series Group (from the’data field placement area’ on the right side of the chart) so that all I have is 1) category group (bottom of chart) and 2) data series (top) chart). Then I can right-click on the data at the top of the chart Series, “Add Calculated Series” is a menu option.

Leave a Comment

Your email address will not be published.