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.
|12345678||8/24/2015 22:49||A_000001||ABC||Rep1||AA||AUTO APPROVAL||N/A'||Do not want to count auto approvals|
|8/24/2015 23:24||A_000010||ABC||Rep1||BB||MANUAL APPROVAL||1st Approver||Sorted by Activity.Date|
|8/25/2015 1:05||A_001000||ABC||Rep1||CC||MANUAL APPROVAL||2nd Approver||Sorted by Activity.Date|
|8/25/2015 3:10||A_001100||ABC||Rep1||DD||MANUAL APPROVAL||3rd Approver||Sorted by Activity.Dat|
I want to correct my previous statement. What I was trying to explain in my original thread is that I have 1 activity with multiple tasks of approval. I need to assign a dimension '1st approved', '2nd approved and so on based on the task create date, excluding auto approvals
you can do this at script level with peek, you could also do this in the front end though you would always need them to be sorted on the correct way, limiting the graph/table functionality
here is a link
First Example doesn't seem to work. I am looking into another one.
My Field Output Should look like
ActivityID, TaskID, TaskCreateDate, TaskStatus, ApproverRank
001,001-01,01/01/2016 00:00:00, Manual, 0
001,001-02,01/01/2016 05:25:44, Manual, 1st Approved
001, 001-03, 01/02/2016 10:15:25, Manual, 2nd Arroved
Also, I would like to have it in the script as a dimension