2 Replies Latest reply on Nov 12, 2018 11:43 AM by Vee Gees

    (Incident) State - Track Pattern

    Vee Gees

      Hi there.

       

      I want to be able to track how an incident passes through various states. There are potentially 6 possible states per 1 incident, e.g.

       

      State:

      1. Opened
      2. Under review
      3. Allocated
      4. Pending release
      5. Deployed
      6. Closed

       

      An incident should be opened first, under review 2nd, allocated 3rd, pending release 4th, deployed 5th and closed 6th.

      1. If incident state = Opened, binary flag of 1, otherwise 0
      2. If incident state = Under review, binary flag of 1, otherwise 0
      3. If incident state = Allocated, binary flag of 1, otherwise 0
      4. If incident state = Pending release, binary flag of 1, otherwise 0
      5. If incident state = Deployed, binary flag of 1, otherwise 0
      6. If incident state = Closed, binary flag of 1, otherwise 0

       

      End results, a 6 digit pattern indicator of how well an incident adheres to process, meaning, 111111 = correct adherence & 000000 = incorrect adherence

       

      Basically I want to be able to track how well incident state procedure is adhered to.

      Please can I get your advice on how best and simplest way to implement this in Tableau?

       

      Any and all help greatly appreciated!