Counting rows in data

[abhi1693r]

Hi,

I have A-E, 5 columns/variables in my data.

Lets say A has 3 options MD,SD and RT.

I have created a multibox to sort with SD and count the entries.

Can I do the same with a text box containing formula? such as

=(Count( DISTINCT {<A={"SD"}>} A))

[lockematthewp]

yes that would provide you with the number of distinct values in A. You can also display them by having a text box with =concat(distinct {<[A]={'SD'}>} [A], ',') 

[abhi1693r]

I wanted to count instead of concat, what should I do?

[lockematthewp]

Your original expression will return the count.

=(Count( DISTINCT {<A={"SD"}>} A))

[abhi1693r]

I was trying something like 

=(Count( DISTINCT {<A={"SD"}>}{<B={"TD"}>} A))

And I noticed that only A=SD condition is applying but B=TD is NOT.

Is there a way to implement both conditions together with 'OR' logical operator??

[lockematthewp]

+ is used for or in set analysis.

=(Count( DISTINCT {<A={"SD"}>}+{<B={"TD"}>} A))