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
vishwasanj
Level V

Searching a value in a column- JSL

Hi All,

 

Can anyone help me with the search for a particular value in a column and try to find the count of that value with the overall count? In the below example, I am trying to search for value "1" in B column. I found 3 occurences in 10 instances so C is marked with 30%. Similarly for A=2, I found 4 occurence of "1" in 12 instances, so C is marked with 33%.

ABC
1130%
187 
190 
165 
11 
165 
13 
11 
134 
15 
2133%
25 
22 
247 
21 
254 
21 
285 
21 
21 
222 
221 

 

 

Thank you 

 

10 REPLIES 10
txnelson
Super User

Re: Searching a value in a column- JSL

You can do virtually anything you want to do in JMP, so yes, there are ways to do what you want.  However, the structure you have is a data table, and it's defaults are based upon a column based analysis table structure, not a cell based structure like Excel.  

To do what you are asking, I would do the following.

Go to "Column Info" for the percentage column.

In the Column Info window, remove the formula property.  This will keep the values, but take away the formula.

Then change the "Data Type" from numeric to character

Close the "Column Info" window

Now go and delete the cell values you don't want.

Jim