Group by in front end

[rathorep]

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

[rathorep]

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? 

[sunny_talwar]

I might be wrong, I just don't know what you have there... can you share your qvf to help you here?

[rathorep]

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.