Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Below is my dummy data,
my requirement is to calculate
Ticket number: Modified Group name: and Total time spent by each group on per ticket.
In below data we have ticket number(just filtered for 1 ticket), Modified group name(Group who modifies the ticket),
Modified Date(Date on which ticket has been modified by group.
Last column i am calculating difference of time on each line. i.e. when Modified date when Ticket first assigned to next group(B) - Modified Date when ticket first assigned to group A
I was trying to sum up last column group by Ticket number and Modified group name by formula
Sum(Aggr((interval((Below(Total ([Modified Date]),1,1)-[Modified Date]),'hh.m')),[Modified Group Name],[Ticket Number]))
But getting only zero for each line.
Please help!
Ticket Number | Modified Date | Modified Group Name | interval((Below(Total ([Modified Date]),1,1)-[Modified Date]),'hh.m') |
1781 | 10/3/2019 12:11 | A | 0.46 |
1781 | 10/3/2019 12:58 | B | 3.11 |
1781 | 10/3/2019 16:09 | C | 14.16 |
1781 | 10/4/2019 6:25 | A | 126.52 |
1781 | 10/10/2019 5:40 | B | 16.22 |
1781 | 10/11/2019 7:37 | C | 25.57 |
but the format we have used in script is d.hh.mm so iam not sure if 39 is not days?
how can we get the result same as in excel format - 17.06:57?
I might be wrong, I just don't know what you have there... can you share your qvf to help you here?
Please find qvf
Needs to be verified if total is coming in days, hours and min format and days are coming correct and it should be in same format as excel.