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

posted on November 12th, 2015

Answered

Trevor Lambiotte asked on November 12, 2015

Hi.
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?
-Trevor

3 answers

Public

Roman Petrusha ⋅ Flexmonster ⋅ November 13, 2015

Please look at this video http://screencast.com/t/vnNQOEpp
It's easy to do!

Public

Trevor Lambiotte ⋅ 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.
http://www.screencast.com/t/6ZXeAfQXBE

Public

Roman Petrusha ⋅ Flexmonster ⋅ November 13, 2015

Hi,
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).

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

3 answers

Please login or Register to Submit Answer