1 Reply Latest reply: Nov 30, 2012 1:35 AM by Johannes Sunden RSS

Replace count (distinct)

Uday Kumar

Hi,


I have a expression which has Count(Distinct EmpID).

I saw the community, they have told that not to use Count(Distinct) as much as possible.

so by which other expression i can replace count(distinct)?

  • Re: Replace count (distinct)
    Johannes Sunden

    Well, if you can load the data in a distinct way in the script already there's no need for the count(distinct ). It does require a little bit of data model review to see if there's a viable way of replacing the count(distinct) functions from your front end.