4 Replies Latest reply: Aug 12, 2016 4:55 AM by Conor O'Kane RSS

    Table: Two columns as single dimension

    Conor O'Kane

      Hi there,

       

      My data is log-type data looks like this

      numberOpened timeopened_byresolved_by
      101/05/2016  00:00:00HW
      201/05/2016  00:05:00YG
      301/05/2016  00:10:00FW
      ............

       

      Where opened_by and resolved_by detail individuals who opened and resolved an incident.

       

      I want to create a table (either flat or pivot) that looks like this:

       

      IndividualNo of incidents openedNo of incidents resolved
      A125
      B814
      C2115
      .........

       

      Can anyone provide any direction? I attach the data.

       

      Thanks,

       

      Conor