cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Group columns based on number of value in a table

I have this table with three columns (dut, vcc, result) (for exemple) :

dut | vcc | result | 
1    | 1.1 | pass
2    | 1.1 | pass
3    | 1.1 | pass
4    | 1.1 | pass
1    | 1.2 | pass
2    | 1.2 | fail
3    | 1.2 | pass
4    | 1.2 | pass
1    | 1.3 | pass
2    | 1.3 | fail
3    | 1.3 | fail
4    | 1.3 | fail

And I want to group by vcc the number of pass so have this table :

vcc | number | 
1.1 | 4
1.2 | 3
1.3 | 1

 What are the easiest ways to move from the first table to the other ?

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Group columns based on number of value in a table

Using Tabulate or Summary. With summary you can get something like this:

jthi_0-1653042199966.png

and tabulate

jthi_1-1653042216480.png

 

do note that vcc should be Nominal column

 

-Jarmo

View solution in original post

1 REPLY 1
jthi
Super User

Re: Group columns based on number of value in a table

Using Tabulate or Summary. With summary you can get something like this:

jthi_0-1653042199966.png

and tabulate

jthi_1-1653042216480.png

 

do note that vcc should be Nominal column

 

-Jarmo