Sort Table by Field Count

debbie_a

Hi,

I have a list of locations in one column with a list of attributes in the second column. I need to count the number of locations attributed to each attribute in a table chart. How can i create this simple result? I haven't had accurate results using COUNT functionality.

thanks!

Godiepi

I'm not sure if I am understanding well what you are trying to do but, you could do a beastmode  Count(Distinct `Location`)

 

then in your table , use the 'List of Attributes Field' as the first column in your table and bring the beastmode to the second column .... this will give you the name of the attribute and the distinct count of locations the attribute is present in

 

is that what you are trying to do ?

Godiepi

I'm not sure if I am understanding well what you are trying to do but, you could do a beastmode  Count(Distinct `Location`)

 

then in your table , use the 'List of Attributes Field' as the first column in your table and bring the beastmode to the second column .... this will give you the name of the attribute and the distinct count of locations the attribute is present in

 

is that what you are trying to do ?

debbie_a

Thanks! That totally worked I was counting on the wrong field...oops.