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?
