2 Replies Latest reply on Mar 2, 2016 2:09 PM by Frank Cheng

    How to display strings properly in tableau

    Frank Cheng

      My data looks like this:

        

                         IDFood1Food2Number
      1AppleBanana1.0
      2OrangeChestnut2.0

       

      After it is imported to tableau, "Number" becomes a measure, "Food1", "Food2" become dimensions.

      If I want to display food1 and food2 for each ID, I need to convert them into measures. But when I do, they become Food1((count(Distinct))) which is number "1".

      If I let them stay dimensions, they can only be displayed horizontally. When change to vertical, the headers are lost.

      But below is the format that I want.

       

      ID1
      Food1Apple
      Food2Banana

       

      It might be a stupid question but I got stuck for a while. Many thanks if anyone could help!