3 Replies Latest reply on Dec 6, 2017 3:17 AM by Mark Bradbourne

    Create a dimension

    laura delaminne

      Hello all,,

      I would like to create a new dimension linked to an other one.

      To explain me;

      I have dimension with number : 52 , 51, 10, 63, 54

      Each number  hasa correspondance : 52 = other;  51 = customer ; 10 = supplier ; etc.  But i don't have a dimension with this info.

       

      Can i create a new dimension ? Linked to the other one.

      In excel i will do a IF formula but here i really don't know what to do. i'm new in tableau.

       

      Thanks for your help !!!

       

      Cheers,

      Laura

        • 1. Re: Create a dimension
          Mark Bradbourne

          You can create a calculation with those values, which should yield the same results.

           

          CASE [Dimension Number]

          When 52 then 'other'

          When 51 then 'customer'

          When 10 then 'supplier '

          etc.....

          END

          1 of 1 people found this helpful
          • 2. Re: Create a dimension
            laura delaminne

            Thank you very much , it works

            Can i ask you an other question ?

            I would like to have my measures as 100% for each column.

            So in the columns have (ex) 10%     20%

                                                          50%     10%

                                                          20%     20%

                                                          15%     25%

                                                          5%       25%

             

            and not   20       60

                           100     30

                            40      60

                            30      75

                            10      75

             

             

            Thanks for your help !!

            Laura

            • 3. Re: Create a dimension
              Mark Bradbourne

              best option, create a calculated field and divide by 100, the use the percentage format.