Dumb question - average of a count

[msarro]

Hey everyone. I'm having a dumb moment, so please be gentle.
I have a number of records, and each one has an ID to identify which set of transactions it belongs to (Local_Call_ID_Trimmed). What I am trying to do is find out what the average number of records is, per transaction. Here is what I'm currently using, which isn't working. I'm not really interested in sorting it in any particular way so i'm not sure if the "by" statement is needed.

index=corrtest sourcetype=AS-CDR|rex field=AS_Local_Call_ID "(?P<AS_Local_Call_ID_Trimmed>\d+)(?=:)"|stats avg(count(AS_Local_Call_ID_Trimmed)) by AS_Local_Call_ID_Trimmed

I know this should be way easier than it is, but for some reason my brain isn't working this morning 🙂 Any help would be appreciated. thanks!

[gkanapathy · Accepted solution]

index=corrtest sourcetype=AS-CDR
| rex field=AS_Local_Call_ID "(?P<AS_Local_Call_ID_Trimmed>\d+)(?=:)" 
| stats count by AS_Local_Call_ID_Trimmed
| stats avg(count)

[msarro]

Worked wonderfully, thank you!