Menu
Download Free Trial

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

Answered

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

Please login or Register to Submit Answer