Sum of time

[#1]

Hello all, I have a chart like this:

TaskName	Parent Task	ExecutionTIme	TotalExecutionTime
Generator1	-	00:05	00:05
Report1	Generator1	00:10	00:15 (This is the sum of time for Generator1 and Report1)
Report2	-	02:00	02:00

How do I calculate the TotalExecutionTIme?

Thanks in advance

Message was edited by: Nemanja Momic

[Anonymous]

Hi Nemanja,

Please can you upload sample excel file with said data,i will play around and try to solve it.

regards

Neetha

[#3]

Hello Neetha,

I do not get data from excel, but here is the data from chart exported to excel

[#4]

bump

[Anonymous]

hi Nemanja,

I am trying find solution,below is one with no success:

if(ParentTaskName = Previous(TaskName),interval(rangesum(Time,Peek(Test)),'hh:mm'),Time) as Test

will update again if any solution.

Regards

Neetha

[agomes1971]

Hi,

i've saw you raw data in excel and i think that for all model to work your taskname should be unique by row or not?

Thanks

André Gomes

[#7]

Hello André,

taskname is unique but sometimes task has dependancy on multiple parent tasks.

Thats why there are same tasknames.

Best regards

[Anonymous]

Hi,

Try:

Data:
LOAD TaskName,
ParentTaskName,
Size,
interval((Time),'hh:mm') as Time ,
interval((Test),'hh:mm') as Test
FROM

(ooxml, embedded labels, table is Sheet1);


NoConcatenate
load TaskName,
ParentTaskName,
Size,
interval((Time),'hh:mm') as Time,
Rangesum(if(ParentTaskName = Previous(TaskName),interval(Rangesum(Time,Peek(Test) ),'hh:mm'),Test)) as Test
Resident Data;

DROP Table Data;