Average of multiple fields

[msarro]

I have three columns each containing a number. I want to have the average for each rows set of numbers. Is there a way to do this with the avg command?

i would like to be able to do something like the following

avg(AS_KPI_SCORE_AVG, PSBC_KPI_SCORE_AVG, PCSCF_KPI_SCORE_AVG)

[David]

I know stats is usually used vertically (one field, summing that way). There may be another method that would work, but you can certainly do it with eval:

YourSearch | eval Average = (AS_KPI_SCORE_AVG + PSBC_KPI_SCORE_AVG + PCSCF_KPI_SCORE_AVG) / 3