2 Replies Latest reply: Sep 24, 2012 9:52 AM by Gaute Holmin RSS

    First calculate durance, then count instances related

      Hi.

       

      I'm on my first prosject after Designer Training, and I have a challenge I'm strugling with.

       

      I have a table that looks something like this:

       

      CriticalityStartDateEndDate
      Critical21.01.2012 12:0021.01.2012 14:00
      Critical22.01.2012 08:0023.01.2012 15:00
      Average21.01.2012 09:0027.01.2012 13:00
      Low21.01.2012 09:00

       

      It's an SLA dashboard I'm making and I want to first calculate the number of hours the incident where active, I've managed to do that in a list with:

       

      =Interval([Close Time]-[Open Time],'hh')

       

      But what I really need to report on is a sum of "critical" events that lasted more than for example 24 hours.

       

      I'm thinking that I might want to have a new row in my table called "durance"?