hi Rita
You can use a custom graph to build this. To create the custom graph, you can use this button when on the report obejcts tab.
Put two barcharts on top of each other and change the bar spacing for the second bar to make it smaller.
Next, edit the roles to change the names to be something sensible. Also allow multiple data assignments for the error bar because you will need to use two data points there.
Go to the properties of the first cell, the one with the two barcharts in it, and set the way color are given, this will ensure, that we only have to set the color for the error bars.
Set the grouping style for the second bar chart, the one that displays the error bars, to stack, so the two measures will be put on top of each other.
That is basically it, you might want to set other properties on how the bar are displayed. Save your custome graph to a folder and add it to the report objects tab.
You need two new aggregated measures computed with the follwoing expressions, you have to adapt it for the data item you want to display (change the name of 'HorsePower'n to the name you need.
errorBarMin, that is the value for the first measre on the errorBars role:
Avg [_ByGroup_] ('Horsepower'n) - ( 1 * StdDev [_ByGroup_] ('Horsepower'n) )
the second aggregated measure looks like this:
errorBars, that is the actual value for the error bars:
2 * StdDev [_ByGroup_] ('Horsepower'n)
Use the custom graph in your report like this:
Learned this techniques from @PetriRoine.
Bruno
... View more