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

[alexandros17]

(If(isnull(taskname),0,taskname) + If(isnull(parenttask),0,parenttask))

/

(If(isnull(taskname),0,1) + If(isnull(parenttask),0,1))

let me know

[avinashelite]

Are this Report1Time+ Generator1Time and Repor2Time are a separate column??

From which column this Time   are coming ???

[#4]

Those are name of tasks, and Time is their execution time taken from the logs.

[maleksafa]

not very clear how you are calculating the avg however you can try the below

=rangeavg(TaskName,ParentTask)

=rangesum(TaskName,ParentTask)

[avinashelite]

can you please  share the sample data ? so that it will be more clear.

[#7]

Hello all, I have edited the first post in order to make it more clear.

[#8]

Not quite what I was expecting.

Could you please review the first post that I edited, for more clarified request?

[Anonymous]

Hi,

Try in script as below:

LOAD TaskName,
[Parent Task],
ExecutionTIme,
if([Parent Task] = Previous(TaskName),interval(peek(ExecutionTIme)+ ExecutionTIme,'hh:mm'),ExecutionTIme) as TotalExecutionTime;
LOAD * Inline
[
TaskName,Parent Task,ExecutionTIme,TotalExecutionTime
Generator1,-,00:05,00:05
Report1,Generator1,00:10,00:15
Report2,-,02:00,02:00
];

Regards

Neetha

[#10]

Hello Neetha,

this is great, but this is just an example.

What would happen if there are multiple parent tasks?

And what would be if the parent task is not previous?

Please check the screenshoot