3 Replies Latest reply on Mar 7, 2016 1:43 PM by Edgar Alvarez

    Creating a Cross tab with data from 1 column

    Edgar Alvarez

      I am working with 3 columns from my data source where 2 of those columns contain several information.

       

      Interaction IDReport_LabelAnswer
      2220Employee Full NameEmployee 1
      2220ResultPass
      2221Employee Full NameEmployee 2
      2221ResultFail
      2222Employee Full NameEmployee 1
      2222ResultPass

       

      What I am trying to achieve is to create a cross tab to be able to show how many Pass or Fail has a single Employee obtain. Something like this:

       

      Employee Full NamePassFail
      Employee 120
      Employee 201

       

      There a several employees within the Report_Label column and have worked with several Interaction Id's.

       

      Is this possible within tableau, possibly creating  a calculated field?