how to calculate pod CPU usage in last 24 hrs

[Carlos Mercado]

Hi all

I am trying to calculate POD CPU usage for the last 24 hrs, I have been trying using avg_over_time and rate(), but the difference is huge. Can someone please recommend the best way to get the pod CPU usage for a long period of time?

Here an example of the query I am using:

sum by (node)(min_over_time(kube_pod_labels{label_project="'<POD label>"}[24h]) * on (pod) group_right () avg_over_time(container_cpu_usage_seconds_total{image!=""}[24h]))

Thanks a lot in advance.