hi
i have one table with different task and its duration as,
TaskAction duration
task1 12.2
task 2 1.90
task1 2.22
using the stats command i found the average duration for the each task ,i want to append those average to the above table as ..
my result sholud be
Taskaction duration avg(duration)
task1 12.2 16
task2 1.90 2.97
task1 2.22 16
... | eventstats avg(duration) as avgdur by Taskaction | table Taskaction duration avgdur