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. Referer Txn_id response_time google abcd1234 42 google abcd1234 43 google abcd1234 44 google 1234abcd 45 google 1234abcd 46 google 1234abcd 47 google 1234abcd 48 yahoo xyz123 110 yahoo 123xyx 120 yahoo 123xyz 130 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: Referer avg(count txn_id) avg(response_time) google 3.5 44.5 yahoo 1.5 120 Any help would be appreciated. Thanks!
... View more