1 Reply Latest reply on Aug 12, 2016 2:02 AM by Simon Runc

    UNIQUES VALUE ARRAY

    mithun aggarwal
    mithun aggarwal Aug 11, 2016 8:08 PM

      Assume a table structure

       

      Table A

       

      col-1 col-2

      1          2

      2          1

      3          2

      3          2

       

      Now i want a dimension/measure that can give me unique values of col1 and col2 combined.

      can way i can do it ?

      • 39 Views
      • Categories: Calculations
      • Tags:
        • 1. Re: UNIQUES VALUE ARRAY
          Simon Runc
          Simon Runc Ambassador Aug 12, 2016 2:02 AM (in response to mithun aggarwal)

          hi Aggarwal,

           

           

          So to combine the fields you can concatenate the columns (this only works on strings, so we need to cast them to strings too)

           

          STR([Col -1])+' '+STR([Col - 2])

           

          we can then take a COUNTD of this new field...or just combine the whole thing into one formula

           

          COUNTD(STR([Col -1])+' '+STR([Col - 2]))

           

          Let me know if that doesn't make sense, or doesn't solve you issue.