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; } } }

Counting elements in list (within a cell)

I am working with results from a Google form.

The spreadsheet has elements within the cell.

user, answer, ...

John Doe, "A,B,C,F,G",...

Jane Doe, "B,D", ...

Richard Roe, "B,G", ...

Is there an easy way to count these elements, so a bar plot will show the following ?

A: _] 1

B:___] 3

C:_] 1

D:_] 1

E:_] 1

F:_] 1

G:__] 2

Accepted answers

Jeff_Perkinson

Make your answer column a multiple response modeling type and the Distribution platform will do that for you automatically.

2020-04-06_10-46-47.279.png

2020-04-06_10-57-24.481.png

Community50353.jmp

All comments

txnelson

Use the Text to Columns to move each letter found and then stack the columns that were created. That will stack them and you can use the Data column for your axis on you bar chart.

names default to here(1);
dt= New Table( "example",
	Add Rows( 3 ),
	New Column( "Column 1",
		Character,
		"Nominal",
		Set Values( {"A,B,C,F,G", "B,D", "B,G"} )
	)
);
dt << Text To Columns( delimiter( "," ), columns( :column 1 ) );

dtStack = dt << Stack(
	columns( :Column 1 1, :Column 1 2, :Column 1 3, :Column 1 4, :Column 1 5 ),
	Source Label Column( "Label" ),
	Stacked Data Column( "Data" )
);

dtStack << Graph Builder(
	Size( 518, 456 ),
	Show Control Panel( 0 ),
	Variables( Y( :Data ) ),
	Elements( Bar( Y, Legend( 3 ), Label( "Label by Value" ) ) )
);