It would be extremely valuable for HubSpot to support aggregate calculations directly in calculated properties, such as average, median, sum, or count of a specific property across contacts, companies, deals, or tickets e.g., average Fit Score across all contacts.
Currently, calculated properties are limited to values on a single record, which blocks many analytics and operational use cases that businesses need.