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.
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
|
Re: Table with Groups with "certain conditions"Thanks a lot Jeff. I was trying to script it using JSL, but this also works !
Aritra
