Ill start off i am newer to splunk....
I am using the following search
index=server source="WinEvent" EventCode=1234 OR EventCode=5678
| eval locked_account_name=mvindex(Account_Name, 1)
| eval account_that_unlokcedit=mvindex(Security_ID, 0)
| transaction startswith="locked out" endswith="unlocked"
| stats sum(duration) as duration by locked_account_name account_that_unlokcedit
| eval min=duration/60
| eval min=round(min,2)
| search account_that_unlokcedit=*APP1234* OR account_that_unlokcedit=*z_xxx* OR account_that_unlokcedit=*APP56789*
I need to chang the min column to minutes..... then i need to get the average of that column(minutes) and put the average in its own column
...
| rename min as minutes
| eventstats avg(minutes) as avgMinutes
...
| rename min as minutes
| eventstats avg(minutes) as avgMinutes