Choose Language Hide Translation Bar
Highlighted
jswislar
Level III

Counting rows

I have a data set with multiple lines of data per individual. The lines of data are medical procedures and I want to get the average number of lines (or procedures) per individual. I'm not sure how to do that.

 

I was able to count the number of lines but I can't take the mean of that since everyone who has 5 lines also has 4 lines and 3 lines and so on. So basically what I think I need is for JMP to count the number of lines, but then only save the highest number. How can I do that?

 

The data structure is like this:

 

ID      Count  

001    1  

001    2  

001    3  

002    1  

003    1  

003    2  

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: Counting rows

the formula would be

 

Col Number(:Count,ID)
Jim

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

Re: Counting rows

the formula would be

 

Col Number(:Count,ID)
Jim

View solution in original post

Article Labels

    There are no labels assigned to this post.