nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Custom Group By Distribution Plots

Neo

I have two column data. Column1 is measured data from parts and Column2 lists Pass or Fail. I would like to plot the full distribution (Pass + Fail) for all the measured data and then stack below it distribution of only passing (Pass) parts. How, to get this working (JSL script would be fine but I would also like to know if this could be done interactively)?

At the moment, I find myself only able to group by Column2 in Distribution plot option and get a distribution for Fails and below it distribution for Pass (when stacked one below the other).

Accepted answers

Neo

Simples...

New Window("My Report",

Distribution(
	Stack( 1 ),
	Continuous Distribution(
		Column( :Col1),
		Horizontal Layout( 1 ),
		Vertical( 0 )
	)
);

Distribution(
	Stack( 1 ),
	Automatic Recalc( 1 ),
	Continuous Distribution(
		Column( :Col1),
		Horizontal Layout( 1 ),
		Vertical( 0 )
	),
	Local Data Filter(
		Close Outline( 1 ),
		Add Filter( columns( :Col2), Where( :Col2== "PASS" ) )
	)
);
);

All comments

tom_abramov

Copy column1 to column1_copy

Create distribution for both column1 and column1_copy

Add Local Data Filter of column2 for both of them (for column1 is not necessary but for simmetry of the charts will be nice)

Choose Pass only in the local data filter of column1_copy

Hope it helps.

BR,

Tom

Neo

Thanks @tom_abramov. I should have specified. I am looking for a solution without changing the data table.

Dan_Obermiller

You can build this interactively as a dashboard. This approach will also generate the script you would need if you want that.

Create your distribution of Column1.

Now Create another distribution of Column1, but add a Local Data Filter that is using Column2. Select the Pass group so that this report window now displays just the Pass observations. I would then collapse the Local Data filter area, but that is up to you.

In the lower-right of each of those report windows, check the box. Now from that same area, click the down arrow and choose to Combine Windows. This will give you both reports in one window, but they are arranged horizontally. Click the filtered report, and drag it to below the non-filtered report.

I think this will give you everything that you need.

Neo

Thanks @Dan_Obermiller . This works and very useful trick to know. However, running the saved script does not reproduce the distribution charts one below the other. They still appear side by side. How to fix this?