https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59153#M14565 <PRE><CODE>index=corrtest sourcetype=AS-CDR | rex field=AS_Local_Call_ID "(?P&lt;AS_Local_Call_ID_Trimmed&gt;\d+)(?=:)" | stats count by AS_Local_Call_ID_Trimmed | stats avg(count) </CODE></PRE> Wed, 17 Aug 2011 15:45:13 GMT gkanapathy 2011-08-17T15:45:13Z https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59152#M14564 <P>Hey everyone. I'm having a dumb moment, so please be gentle.<BR /> 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.</P> <PRE><CODE>index=corrtest sourcetype=AS-CDR|rex field=AS_Local_Call_ID "(?P&lt;AS_Local_Call_ID_Trimmed&gt;\d+)(?=:)"|stats avg(count(AS_Local_Call_ID_Trimmed)) by AS_Local_Call_ID_Trimmed </CODE></PRE> <P>I know this should be way easier than it is, but for some reason my brain isn't working this morning <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Any help would be appreciated. thanks!</P> Mon, 28 Sep 2020 09:48:14 GMT https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59152#M14564 msarro 2020-09-28T09:48:14Z https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59153#M14565 <PRE><CODE>index=corrtest sourcetype=AS-CDR | rex field=AS_Local_Call_ID "(?P&lt;AS_Local_Call_ID_Trimmed&gt;\d+)(?=:)" | stats count by AS_Local_Call_ID_Trimmed | stats avg(count) </CODE></PRE> Wed, 17 Aug 2011 15:45:13 GMT https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59153#M14565 gkanapathy 2011-08-17T15:45:13Z https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59154#M14566 <P>Worked wonderfully, thank you!</P> Wed, 17 Aug 2011 16:11:46 GMT https://community.splunk.com/t5/Splunk-Search/Dumb-question-average-of-a-count/m-p/59154#M14566 msarro 2011-08-17T16:11:46Z