1 Reply Latest reply: Oct 15, 2013 2:16 AM by David Norton RSS

    Profiling - Distinct Field Values (per field)

    David Norton

      Hi Everyone,

       

      Is there a good way, when profiling a new data set, to show the distinct values per field?

       

      I've got the following working in a straight table (with dimensions $Table and $Field), when any single field is selected:

       

           =Num(Count(Distinct [$(=$Field)]), '#,##0')

       

      ...but ONLY when a single field is selected.  If 2+ fields are selected, the straight table is blank.  It would be immensely helpful to see the distinct values in each field.

       

      Any ideas?

       

      Thanks,

      DJ