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


    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.