
Not applicable
2015-01-28
04:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Average of Average with aggr()?
I am trying to figure out how to calc the average of an average in a single step.
I have n PROVIDER which measure m URL HTTPSESSIONDURATION. The HTTPSESSIONDURATION and the number of measurements varies huge per URL. Therefore, I decides to normalize the measurement per URL for the PROVIDER and time (yyww). Than the weight of each URL should be equal. No matter how fast it is or how many measurement I have.
The next step will be a second average of the HTTPSESSIONDURATION per PROVIDER and YYWW (year-week).
avg(aggr(avg ( HTTPSESSIONDURATION )/ avg (total <yyww,URL> HTTPSESSIONDURATION ), URL, PROVIDER,yyww))
I double checked in EXCEL (average of the PIVOT result) and it's different. What's wrong?
329 Views
0 Replies
