Average count of events per field grouped by anoth...

rmm1982 · ‎10-06-2023

Hello All,

I'm a relative newbie and hoping the community can help me out. I'm kind of stuck on a query and I can't figure out how to get the correct results.

I have an event that has a referer and a txn_id. Multiple events with the same referer field can have the same txn_id.

What I am trying to do is get the average number of txn_ids per referer and the avg of response times for that. So something like this:

Any help would be appreciated.

Thanks!

ITWhisperer · ‎10-06-2023

Try something like this:

| stats dc(Txn_id) as unique_tx_ids count avg(response_time) as average by Referer
| eval average_count_txns_id=count/unique_tx_ids

rmm1982 · ‎10-06-2023

Thanks! That seemed to do it

Average count of events per field grouped by another field