Count distinct?

[Anonymous]

I have the following data and as can be seen there is one row for each question, each of these rows have the same (assignment)number.

How can I count how many different (assignment)numbers I have? Right now when I count I get 13 times as many as I would like as the (assignment) number appears 13 times for each questionaire.

Thanks!

[Anonymous]

I ended up using the following expression to do the count: Count( distinct number)

[sunny_talwar]

But wasn't this proposed by okolyug16‌ already? If this is what worked for you, I would suggest marking there response as the correct answer instead of your own.

Thanks,

Sunny

[ToniKautto]

To be fair I did not see the number field in your initial screenshot.

[Anonymous]

Yes sorry, of course!