I have the following query :
... | chart list(time) by request actor
Where time it returns the time for each actor such as
actor1 | actor2 |
10 20 | 10 |
How can I add a new column with the averages for each one?
You didn't list the first column of the chart. If I understand your chart correctly, that would be request. Thus, just run avg() by request.
| stats avg(*) as * by request