How to Highlight some distributions in graph

yummy — Sun, 11 Jun 2023 11:14:40 GMT

Hello:) The figure above is a part of my question. As you can see at the picture, I want to highlight some elements whose Cpk is smaller than 1.

Somebody help me.. Thank you in advance:)

Re: How to Highlight some distributions in graph

Thierry_S — Tue, 08 Jun 2021 22:52:51 GMT

Hi,

Assuming that your data is in stacked format (i.e., Ys = Data are all in 1 column and the Xs = Label are in a second column), create a new column of Row State type and enter the formula below:

If(
	Col Mean( :Data, :Label ) - Col Std Dev( :Data, :Label ) * 3 < :Data <=
	Col Mean( :Data, :Label ) + Col Std Dev( :Data, :Label ) * 3,
	Color State( "red" ),
	Color State( "black" )
);
:FORMAT << Copy to Row States();

You can easily fine tune the range of CPK by modifying the Std Dev multipliers (here set to 3 sigma).

I hope this helps.

Best,

topic Re: How to Highlight some distributions in graph in Discussions

How to Highlight some distributions in graph

Re: How to Highlight some distributions in graph