Mean - ObjectVision/GeoDMS GitHub Wiki

Aggregation functions mean

• mean(a)
• mean(a, relation)

• mean(a) results in a parameter with the average of the non null values of attribute a.
• mean(a, relation) results in a an attribute with the average of the non null values of attribute a, grouped by relation. The domain unit of the resulting attribute is the values unit of the relation.

• attribute a with Numeric value type
• relation with value type of the group CanBeDomainUnit

1. The values unit of the resulting data item should match with regard to value type and metric with the values unit of attribute a.
2. The domain unit of argument a and relation must match.

parameter<uint32> meanNrInh                := mean(City/NrInhabitants); result = 375
attribute<uint32> meanNrInhRegion (Region) := mean(City/NrInhabitants, City/Region_rel);

domain City, nr of rows = 7

domain Region, nr of rows = 5