Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
ashutosh_rastogi
Active Contributor

Control charts are one of the often used statistical charts. I will not get into further details of what the control chart is, its available at the following wiki page

https://en.wikipedia.org/wiki/Control_chart

Today, Lumira does not have control charts available as one of the default charts. However, that does not mean you cannot use Lumira to address your control charts usecase, following are the options

  • Develop your own extension and use it in Lumira (provides you more control on look and feel)
  • Or use the following approach to achieve it via the line charts

Here is the dataset that I am going to use, simply a set of 25 data points

Serial12345678910111213141516171819202122232425
Data157-2-5-1072-8-7-10-2-7-11-15-20-3-8-12-18-194-3-8-14-19

Step1

  • Import the data in Lumira and choose a line chart
  • Display the data against serial, here is how it would look like

Step2

Now create few custom calculations

  • Standard Deviation = [Power((Average(Power({DS1.Data} - Average({DS1.Data}),2))),0.5)]
  • Mean = Average({DS1.Data})
  • UCL = {Mean} + 3*{Standard Deviation}
  • LCL = {Mean} - 3*{Standard Deviation}

Additionally

  • Go to cog wheel option and check "Show Data labels"
  • Choose a custom color palette to color the lines based on your choice
  • What you would get in Visualise room would be like below

Step3

Drag the chart on to the story page and make few changes to beautify the chart

  • Hide the dot marks on the specific lines by choosing no color for the dots
  • Hide label marks for the Mean, UCL and LCL lines by choosing no color for the labels (except the last one, you will know why :smile: )
  • Choose the last label color on the lines to be same as that of line color
  • Change the line style for the Mean, UCL and LCL
  • Hide the legend title
  • Position the legend based on your choice
  • Hide the horizontal axis line, ticks and axis labels from the bottom

What you get is as follows

Hope this addresses the use-case, let me know if you have thoughts or requirements to improve this further.

5 Comments