Adding an Error Bar to Charts in SAP Analytics Cloud

| Analytics , SAP Analytics Cloud ,

Businesses often work with large number of data points to perform analysis and take important decisions. Collecting billions of data points and analyzing a sample of it through graphical representations can be difficult and at times misleading as well. The most common approach to solve this problem is to use a measure of variability using error bars. Error bars are graphical representations of the variability of data and used on graphs to indicate the error or uncertainty in a reported measurement.In this blog, we will see how to create an error bar in SAP Analytics Cloud (SAC).

Go to SAP Analytics cloud in the browser and click on create story.

  1. Click on the “Add a Canvas Page”.

story-sap-analytics-cloud

  1. Click on Chart.

chart-sap-analytics-cloud

  1. Select a data source.

datasource-sap-analytics-cloud

  1. Add required Measures and Dimensions

visualization-sap-analytics-cloud

  1. Click on “More Actions” (…) on the right of the chart and select “Add Error Bar…”

error-bar-sap-analytics-cloud

There will be two types of error bars.

  1. Fixed
  2. Dynamic

 

Fixed type Error Bar:

This type allows static values only. A menu will be displayed on the right to Create Error Bars. In this section, it allows us to create error bars based on the percentage values and accepts only fixed values. For this example, ±5% is used for quantity. Define lower error value as -5 and upper error value as +5 as shown below.

error-bars-sap-analytics-cloud

In the properties sheet, by default the “Error Range Labels” will be selected, if needed it can be toggled.

 

Dynamic type Error Bar:

This type allows dynamic values only. In this example, there are two more measures added to the data source denoting the low and high value of the error. Below is the screen shot of the data source.

dynamic-error-bar-sap-analytics-cloud

In the dynamic type property sheet select the measures for the respective error values.

In the screen shot below for each city there are different error ranges.

error-ranges-sap-analytics-cloud

There will be other options

  1. To enable or disable data labels for the chart
  2. To adjust the width of the error bar
  3. To change the color of the error bar

Below is the screen shot with all the options enabled.

error-bar-sap-analytics-cloud

Share with:

FacebookTwitterLinkedIn