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.

       

      Luca