[v23.3.x] Add partition aggregation to some metrics

[vbotbuildovich]

Backport #15966 to branch v23.3.x. Note that this issue was created as a placeholder, since the original PR's commit(s) could not be automatically cherry-picked.
Here are the commands to execute:

git checkout v23.3.x
git checkout -b vbotbuildovich/backport-15966-v23.3.x-162
git cherry-pick -x 1ab66f971885835d590c46dca1795f3567e81e94 04b15356b894750668f036fd31ca81611f8ea9f5 27e6e2b3f5b78a3a1e2c1094d9e195c99070711e 65c0a896008fec511b224e484201794bf3fb7680

git push origin vbotbuildovich/backport-15966-v23.3.x-162
gh pr create \
  --title "[v23.3.x] Add partition aggregation to some metrics" \
  --base "v23.3.x" \
  --label "kind/backport" \
  --head "vbotbuildovich/backport-15966-v23.3.x-162" \
  --draft \
  --repo "redpanda-data/redpanda" \
  --milestone "v23.3.x-next" \
  --body "Backport of PR https://github.com/redpanda-data/redpanda/pull/15966 "