6 Replies Latest reply: Mar 18, 2016 6:37 AM by Luca Ganugi RSS

    Distinct count on a field

    Luca Ganugi

      Hello everyone,

      i've got a problem.

      I've a key field named DATE. But i want to distinct count the values of DATE only in a particular table.


      if i simply set: count(distinct(DATE)) i'll get the sum of the distinct date over the different tables with the field DATE.


      How can i achieve this?


      tnx in advance.