Referer | Txn_id | response_time |
abcd1234 | 42 | |
abcd1234 | 43 | |
abcd1234 | 44 | |
1234abcd | 45 | |
1234abcd | 46 | |
1234abcd | 47 | |
1234abcd | 48 | |
yahoo | xyz123 | 110 |
yahoo | 123xyx | 120 |
yahoo | 123xyz | 130 |
Referer | avg(count txn_id) | avg(response_time) |
3.5 | 44.5 | |
yahoo | 1.5 | 120 |
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
Thanks! That seemed to do it