4 Replies Latest reply: Jul 16, 2016 6:17 PM by Branislav Bujnak RSS

    How to Rank Approval Activities?

    Branislav Bujnak

      Dear Community,

       

      I am struggling with the last part of my script and need help.

       

      I have  task with 5 approval process activities. I need to create a calculated dimension '1st, 2nd, 3rd, .... Approver' based on the time when they approved the task.

       

      Please see attached example.

       

      Thanks in advance for your help.

       

      Branislav

       

               

      Task.IdActivity.DateActivity.IdTaskOwner.NameTaskOwner.TitleActivityActor.Id.NameActivity.StatusApproverLevelNotes
      123456788/24/2015 22:49A_000001ABCRep1AAAUTO APPROVALN/A'Do not want to count auto approvals
      8/24/2015 23:24A_000010ABCRep1BBMANUAL APPROVAL1st ApproverSorted by Activity.Date
      8/25/2015 1:05A_001000ABCRep1CCMANUAL APPROVAL2nd ApproverSorted by Activity.Date
      8/25/2015 3:10A_001100ABCRep1DDMANUAL APPROVAL3rd ApproverSorted by Activity.Dat