Hi,
Is there a way to specify "weighted average" as the aggregation rule for a metric in Framework Manager 10.2?
Thanks
CoolP
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 ?
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