How to find count of same values repeated in the same row of different columns in spotfire.

[Vignesh Kannan]

hello all,

i have table as below

Fruits

column1

column2

column3

column4

column5

column6

column7

column8

column9

column10

count 2

count 3

count 4

Apple

2

2

4

4

3

3

2

3

3

3

0.3

0.4

0.2

Banana

3

2

3

4

4

4

2

2

2

2

0.5

0.2

0.3

Orange

4

4

4

4

4

4

2

3

3

4

0.1

0.2

0.7

here above i wanted to find countof occurences of 2 ,3,4 in the same/total count of rows .

can you help me is acieving the above scenerio.

thanks.

[Kevin Flynn]

You can unpivot the table.

This will create the table as

Fruits Category Value

Apple Column1 2

Apple Column2 2

Apple Column3 3

 

Once there, you can either do an Over statement using UniqueCount. That or just create a crosstable.