Hello Everyone!!
I need to calculate percentage on sum of Date which is in day, hour and min format. I have calculation in 2 columns:
Time taken by BAS Team-
Formula used-
interval(sum(Aggr(
if ("Modified Group Name"='BAS',
Interval(sum(Aggr(Interval(Rangemax(Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm'),0),[Ticket Number],([Modified Date],(NUMERIC)))),'d.hh:mm')
Total Resolution Time- Overall time consumed
Formula Used-
Interval(sum(Aggr(Interval(Rangemax( Interval((Above(TOTAL [Modified Date],1) - [Modified Date])*(-1), 'd.hh.mm'),0),'d.hh.mm'),
[Ticket Number],([Modified Date], (NUMERIC)))),'d.hh:mm')
Now the requirement is , I want to calculate the time in percentage and not in sum. Like how much percent BAS team worked and how much percent in total time spent.
Please note I have multiple tickets.
| Ticket Number | Modified Group Name | Modified Date | Time taken by BAS Team
(Days/Hour/Min) | Total Resolution Time
(Days/Hour/Min) |
| | | | 2.01:59 | 25.15:37 |
| 17623648 | Desk | 9/6/2019 7:37 | 0.00:00 | 0.00:00 |
| 17623648 | CEM | 9/6/2019 14:51 | 0.00:00 | 0.07:13 |
| 17623648 | OS | 9/13/2019 6:44 | 0.00:00 | 6.15:53 |
| 17623648 | CEM | 9/17/2019 9:59 | 0.00:00 | 4.03:15 |
| 17623648 | DESK | 9/23/2019 8:52 | 0.00:00 | 5.22:52 |
| 17623648 | CEM | 9/24/2019 8:02 | 0.00:00 | 0.23:10 |
| 17623648 | BAS | 9/26/2019 10:02 | 2.01:59 | 2.01:59 |
| 17623648 | CEM | 9/26/2019 15:32 | 0.00:00 | 0.05:30 |
| 17623648 | DESK | 10/1/2019 23:15 | 0.00:00 | 5.07:43 |
Kindly help!
