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)
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