Pareto chart in SAP Analytics Cloud
In this blog we will explain you how we can create a Pareto chart in SAP Analytics Cloud using a Live Data connection to BW. A Pareto chart is a type of chart that contains both bars and a line graph, where individual values are represented in descending bars and the cumulative total is represented by the line.
The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors. In quality control, Pareto charts are useful to find the defects to prioritize in order to observe the greatest overall improvement. It often represents the most common sources of defects, the highest occurring type of defect, or the most frequent reasons for customer complaints, and so on.
SAP Analytics Cloud
We will start with the part in SAP Analytics Cloud.
By default, available we can add a Combination Column & Line chart to our Story.
Next we will add our individual values to the Column Axis and the cumulative total to the Line Axis.
Our individual values we get directly from the Composite provider in the BW query.
The cumulative total, we will calculate in the BW query which I will explain later on in this blog.
As last step in SAP Analytics Cloud, we sort the chart on our individual values from Highest to Lowest.
BW Query Designer in Eclipse
Now let’s have a look at how we can create the measures for a Pareto chart.
In the BW query we will create 3 Calculated Key Figures (CKF): a grand total, a cumulative and a cumulative percentage share.
The first CKF, is a Grand Total/Overall Result formula on the individual values.
The second CKF, is a Cumulated Result from the individual values.
These 2 CKF will be used in the formula of the last CKF.
Here we calculate the Percentage Share of the Cumulated Result to the Overall Result.
This Cumulated Percentage Share is the Measure we need in SAP Analytics Cloud to create the Pareto chart.
I hope that this blog post helps in understanding that with some extra calculations we can create some nice out-of-the-box solutions in SAP Analytics Cloud.
Please don’t hesitate to provide any feedback in the comment section below! If you are interested in more content related to SAP Analytics Cloud, I encourage you to follow this tag:
Simon Van Herck
Analytics & Business Intelligence Consultant bij Cubis