Can I do a distinct count of non-numeric/integer/float fields? (e.g. distinct count of colors in your demo)


I would like to do a simple distinct count on a field. I can do this on numeric or float fields but I can’t seem to figure out how to do it on string fields.
Is this something that is possible?

3 answers

Roman Petrusha Staff November 13, 2015

Please look at this video
It’s easy to do!

trevlamb November 13, 2015

Hi Roman. Thanks very much for the response. Yes, it’s much easier than I thought. It does however appear (to me) that it’s not working in the form of a calculated field.
As you can see in the video below, I was expecting the calculated field to yield the same result as the way you did it.
Thanks again.

Roman Petrusha Staff November 13, 2015

Thank you for noticing that.
We’ve added this issue to our bug tracking system.
The fix will be available within the one of our minor releases (in December).

Please login or Register to Submit Answer