Forum Discussion

mmandich's avatar
mmandich
New Member
3 years ago
Solved

Matrix with binned values for multiple columns

Hello,

 

I'm looking to create a matrix with counts based on how many values are in a bin.

 

My table has a list of sites. For each site, there are 10 or so attribute columns with a value between zero and ten (only the first attribute pictured below). For each attribute I've used a conditional column make custom bins (third column of graphics)

So for each attribute, there will be X sites in the 5 to 7.5 bin, Y in the 7.5 to 10 bin, etc.

 

I'd like to make a matrix like this -

 

Bin            Attribute 1            Attribute 2            Attribute 2

0-2.5           site count

2.5-5           site count

5-7.5           site count

7.5-10         site count

 

So far have not been successful. How do i do this/is it possible?

1 Reply