6 Replies Latest reply on Apr 11, 2018 9:04 AM by Deepak Rai

# Help with table Calculations

Hi,

I need to calculate the time difference between "Assignment Group" and "Assigned to Duration" for each INC Number and have it returned in a column in my sheet.

I also need to have the record that holds "Assignment Group" return the Value data.

I'm at a loss on how to formulate these arguments.

Thanks, Lisa

• ###### 1. Re: Help with table Calculations

Hi Lisa,

Here It is

Calculation 2 shows difference in Seconds and I formatted it to hh;mm;ss in Calculation 3

Thanks

Deepak

If This Helps, Pl mark it Helpful and CORRECT to Close Thread.

• ###### 2. Re: Help with table Calculations

Thank you! I'll bookmark and study this. Very helpful.

• ###### 3. Re: Help with table Calculations

Welcome!!!

• ###### 4. Re: Help with table Calculations

Hi again, I think I missed a part of what I was looking for.

In the data source a record can have multiple Assignment Group to Assigned to Duration hops.

I would like to be able to see the duration of time the record spent between Assignment Group & Assigned to Duration definitions for each Value.

With your earlier solution I get Total Time combined without understanding how long it took for a group to actually assign (acknowledge) the ticket. My mistake in not explaining fully. Thanks

 Number Definition Start Value INC0249438 Assignment Group 2018-04-09 01:49:55 Help Desk INC0249438 Assigned to Duration 2018-04-09 02:13:45 Tech1 INC0249438 Assigned to Duration 2018-04-09 02:17:35 Tech2 INC0249438 Assignment Group 2018-04-09 02:17:35 Help Desk2 INC0249438 Assigned to Duration 2018-04-10 00:09:38 Tech4

i.e.,

Ticket#          Assignment Group   Total Time To Acknowledge

INC1234      Help Desk                 0:27:40

Help Desk2                21:52:03

• ###### 5. Re: Help with table Calculations

give me some time for this

• ###### 6. Re: Help with table Calculations

Hi Lisa,

Here it is:

You do not Have anything in your raw data which states when the Assignment Group Changes so you need to group your data. I grouped it and Modified the Calculations. So Here is the Result. Please See attached

Thanks

Deepak