cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
FN
FN
Level VI

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: Counting elements in list (within a cell)

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

 

 

-Jeff

View solution in original post

4 REPLIES 4
txnelson
Super User

Re: Counting elements in list (within a cell)

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.

count.PNG

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" ) ) )
);
Jim
Jeff_Perkinson
Community Manager Community Manager

Re: Counting elements in list (within a cell)

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

 

 

-Jeff
FN
FN
Level VI

Re: Counting elements in list (within a cell)

Just to complete, this works great and allows the later use of Recode functionality (as some elements have commas within).

txnelson
Super User

Re: Counting elements in list (within a cell)

It needs to be noted, that currently, Multiple Response columns are not supported for many platforms.  Therefore, if there was a need to analyze resulting columns based upon the multiple response column, the Text to Columns(), Stack Table needs to be kept in your back pocket as a tool to use for such analyses

Jim