Support histogram fields in rate aggregation

[dgieselaar]

#60674 added a rate aggregation to Elasticsearch. It does currently not support histogram fields:

“Field [transaction.duration.histogram] of type [histogram] is not supported for aggregation [rate]”

To use the rate aggregation in the APM app, we'd need support for histogram fields. We currently have a bug which seems like an ideal candidate to fix by using the rate aggregation: elastic/kibana#77474

See also the discussion in the original issue: #60674 (comment)

[elasticmachine]

Pinging @elastic/es-analytics-geo (:Analytics/Aggregations)