5 Replies Latest reply on Nov 28, 2018 7:00 AM by Jim Dehner

    Combining Multiple Dimension Values Into One

    Scott Coulter

      Hi,

       

      My excel data is structured as per the below, where each distinct ID can have up to 4 product labels attached to it.

       

      IDProduct Group 1Product Group 2Product Group 3Product Group 4
      1LoansCredit CardsDebit Cards
      2Credit CardsLoansSavings AccountsDebit Cards
      3Savings AccountsCredit CardsDebit Cards
      4Foreign CurrencyDebit CardsSavings AccountsCredit Cards
      5Debit CardsLoansSavings Accounts

          

      I want to create a dimension from all the distinct contents of Product Group 1, 2, 3 and 4, so that I can produce a bar chart with the total number of ID's per each Product.

       

      I have tried creating a combined field, however that appears to concatenate the data together seperated by a comma.

       

      Is it best to do this within Tableau, or in the source data?

       

      Thanks,