"Weighted Average" aggregate rule

[CoolP]

Hi,


Is there a way to specify "weighted average" as the aggregation rule for a metric in Framework Manager 10.2?




Thanks
CoolP

[blom0344]

A weighted average uses at least 2 measures, usually a number and a measure , like  sum(number*measure)/sum(number).  How would you apply such a rule for a given measure ?

[CoolP]

Hi Bloom,


I'm aware of how "Weighted Average" is Calculated.


Assume a hierarchy




L1: State
L2: Region
L3: Street


Assume S1,S2,S3 are 3 streets and they constitute to 40%,30% and 30% of length in a Region
If the crashes on S1,S2,S3 are 50,20,30


Then the Region Crashes = 35  (.4*50+.3*20+.3*30)


When the user is at the lowest level of the hierarchy (street) we should show the "number of crashes" per street
When the user drills up to "Region Level", weighted average should apply as explained above.


Thanks
CoolP