Aggregated metrics currently don't aggregate on data_stream.namespace attribute which is used in routing to achieve logical isolation within Elasticsearch. The workaround for this involves adding custom resource attributes to the elastic apm connector but given the usefulness of this metric, it makes sense to add it globally.
See: https://elastic.slack.com/archives/C031284ANNL/p1770727291228679