cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member

Problem

You want to create a Control Chart in Sisense to study how a process changes over time. A control chart always has a central line for the average, an upper line for upper control limit and a lower control limit. By comparing current data to these lines, you can draw conclusions about whether the process variation is consistent (in control) or is unpredictable.
 

Solution

  • Install “qicharts” package in R console.
install.packages(qicharts);
  • R script (Copy paste to Sisense Formula)
Center Line:
library(qicharts);

y<-c(do.call('cbind',args));

sisense_result<-qic(y,chart='i');

sisense_result$cl
Upper Control Limit:
library(qicharts);

y<-c(do.call('cbind',args));

sisense_result<-qic(y,chart='i');

sisense_result$ucl
Lower Control Limit:
library(qicharts);

y<-c(do.call('cbind',args));

sisense_result<-qic(y,chart='i');

sisense_result$lcl
 

Discussion

Control charts, also known as Shewhart charts or process-behavior charts, in statistical process control, are tools used to determine if a manufacturing or business process is in a state of statistical control.

Rate this article:
Version history
Last update:
‎03-02-2023 09:45 AM
Updated by:
Contributors