Issue can be for example in jobs like GitLab runner where it creates pod for every CICD pipeline but containers have the same name in the pods.
This is what i am using currently
sum(rate(container_cpu_usage_seconds_total{container!=""}[10m])) by (pod) * 100