9 Replies Latest reply on Jul 25, 2018 2:20 AM by Rajhesh Kumar A S A

    Filter by occurrence condition

    Rajhesh Kumar A S A

      Hi,

       

        I need to filter those records where a TT has multiple case orders and order of the team handling the cases should be 1st level Technical and 2nd level technical resp. This team alignment can be tracked through case orders creation date. To be more simple, I need those TTs and case orders, where the first case handling team should be 1st level Technical and second case handling team should be 2nd level technical. Below is the sample table and output

          

      Input Table :

      Incident IDCase orderCase order Created timeHandled by
      TT1710151CT000012756363402-01-18 16:292nd Level Tech
      TT1710151CT000012759550702-01-18 22:272nd Level Tech
      TT1710151CT000012764448703-01-18 5:201st Level Tech
      TT1710882CT000012765196403-01-18 6:221st Level Tech
      TT1710882CT000012766498403-01-18 7:512nd Level Tech
      TT1711243CT000012769083803-01-18 10:381st Level Tech
      TT1711243CT000013343871707-02-18 12:052nd Level Tech
      TT1711884CT000012774718603-01-18 20:231st Level Tech
      TT1711884CT000012775341803-01-18 22:151st Level Tech
      TT1716438CT000012829209607-01-18 22:542nd Level Tech
      TT1716438CT000012854455709-01-18 16:082nd Level Tech
      TT1716438CT000013241234901-02-18 14:511st Level Tech
      TT1730077CT000013000356419-01-18 0:421st Level Tech
      TT1730077CT000013008332819-01-18 11:012nd Level Tech

       

      Output should be :

      Incident IDCase orderCase order Created timeHandled by
      TT1710882CT000012765196403-01-18 6:221st Level Tech
      TT1710882CT000012766498403-01-18 7:512nd Level Tech
      TT1711243CT000012769083803-01-18 10:381st Level Tech
      TT1711243CT000013343871707-02-18 12:052nd Level Tech
      TT1730077CT000013000356419-01-18 0:421st Level Tech
      TT1730077CT000013008332819-01-18 11:012nd Level Tech

       

      The above output is derived based on Ascending Case order created time and Ist team that has handled the case order should be 1st level tech and second team should be 2nd level tech.

       

      Kindly provide me the calculation field formula, using Fixed, IF & AND conditions.

       

      Thanks.