4 Replies Latest reply on Jul 12, 2018 3:57 AM by Levan Uridia

    Combine two calculations into one

    Levan Uridia

      Hi All

       

      Could anyone help with this problem

       

       

      I have the following table

         

      Person Simple Task Compl Task
      p1ANULL
      p1DC
      p1AC
      p1BC
      p1AL
      p2AC
      p2DC
      p2ANULL
      p2BNULL
      p2A

      C

       

      I want to calculate number of simple tasks distinct from task D as well as number of complicated tasks where simple task is distinct from D

      I can simply do this by COUNT(Simple Task) and COUNT(Compl Task) both filtered with Simple task in {A,B} and I get

       

      Worksheet 1

       

      Simple task            COUNT(Simple Task)

       

      A                               6

       

      B                               2

       

       

      Worksheet 2

       

      Compl task            COUNT(Compl Task)

       

      C                              4

       

      L                               1

       

      But what I want is to see both on one and the same worksheet like below

       

      Calculation X               COUNT(Calculation X)

       

      A                                       6

       

      B                                       2

       

      C                                       4

       

      L                                        1

       

       

      Is it possible within tableau not modifying the table?

       

      Thanks in advance

       

      Levan