Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
ad
ad
Level II

Table with Groups with "certain conditions"

Hi,

 

I have a question :

 

For a dataset like this :

 

Group

Score

A

80

A

34

A

67

B

21

B

97

B

88

C

87

C

56

C

61

.........and so on 

 

I want to create a table which shows Group (A/B/C etc.), and "number of rows" with Scores between a certain range like 80< Score < 100 for each Group. 

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Table with Groups with "certain conditions"

I would use the Formula Editor to create a new column to indicate that a row met the condition and then use that new column along with your Group column in Tables->Summary in the Group role.

 

 

Group

Score

Score in Range

A

80

No

A

34

No

A

67

No

B

21

No

B

97

Yes

B

88

Yes

C

87

Yes

C

56

No

C

61

No

 

JMPScreenSnapz321.pngJMPScreenSnapz322.png

 

-Jeff

View solution in original post

2 REPLIES 2
Highlighted
Jeff_Perkinson
Community Manager Community Manager

Re: Table with Groups with "certain conditions"

I would use the Formula Editor to create a new column to indicate that a row met the condition and then use that new column along with your Group column in Tables->Summary in the Group role.

 

 

Group

Score

Score in Range

A

80

No

A

34

No

A

67

No

B

21

No

B

97

Yes

B

88

Yes

C

87

Yes

C

56

No

C

61

No

 

JMPScreenSnapz321.pngJMPScreenSnapz322.png

 

-Jeff

View solution in original post

Highlighted
ad
ad
Level II

Re: Table with Groups with "certain conditions"

Thanks a lot Jeff. I was trying to script it using JSL, but this also works !

 

Aritra

Article Labels

    There are no labels assigned to this post.