4 Replies Latest reply on Mar 2, 2017 11:44 PM by Mahfooj Khan

    Calculate average time per root cause

    Parimal p

      Hi there,

      I am currently doing a root cause analysis of tickets and their effective root causes.

      One ticket can have multiple root cause and hence ticket id appear multiple times compared to root causes linked to it but will have the same time taken.

      I am trying to find the time taken by each ticket id divide by frequency of occurrence of ticket ID.

       

      Some sample data

        

      IDTimeRoot cause
      w130RC1
      w130RC2
      w130RC3
      w230RC1
      w230RC2
      w310RC3

       

      So simply i need RC1 have time 10 hours for w1, 15 for w2 ; RC2 have time 10 hours for w1 and 15 for w2 and RC3 have 10 hours for w1 and 10 for w3.

       

      I am thinking that the answer is very straight forward but couldn't think of it. I am getting aggregate and non aggregate cannot be combined error when creating a calculated field.

       

      Thanks in advance