What monitor service do you use?
It's possible to group(merge) all metrics on elastic side using a transform, that means you would index metricbeat data as is and have a transform which queries that index and writes a secondary index, which transforms the data into the format you want. It's advised to use at least 7.7.