7 Replies Latest reply on Jul 26, 2018 4:55 AM by Okechukwu Ossai

    How to get horizontal and vertical count of values related to a specific person/group

    Rajeshwari Guddeti

      Hello Everyone,

       

      Below is my data set:

         

      IDAssigneeCustomer Name
      1GeorgeLinda
      2JackLinda
      3JeremyLinda
      4LindaLinda
      5SamSam
      6JackSam
      7JeremySam
      8LindaSam
      9MickySam
      10JohnChris
      11ChrisChris
      12GeorgeChris
      13JackJack
      14JeremyJack

       

      I have columns of Assignee, Customer and ID. In this data there are few assignees who also acts as customer some times. Each customer may assigne ticket to himself/herself or assign it to others. Similarily each assignee can resolve their own tickets or tickets assigned by others. Below is the pivot table that is generated in Tableau:

      FOr example Linda acts as a customer as well as Assignee. Linda assigns tickets to self and to other people in team and also will resolve tickets assigned by others. In this case I want to see total tickets worked by Linda as (4+1 = 5) -> 4 tickets among which she has assigned 3 to others and 1 to self and there is another 1 ticket which has been assigned to her by Sam.

       

      How can i get this count?

       

      Please find attached excel sheet and twbx file.

       

      Any help would be greatly appreciated!