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

    UNIQUES VALUE ARRAY

    mithun aggarwal

      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 ?

        • 1. Re: UNIQUES VALUE ARRAY
          Simon Runc

          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.