I am trying to create a dashboard/table in Grafana which shows which kubernetes pod has the highest CPU usage at a given time.
For example, I have a deployment: AppA with 3 pods.
10AM
Pod1:0.5 core
Pod2:0.6 core
Pod3:0.8 core
At 10AM, it should return Pod3.
11AM
Pod1:0.4 core
Pod2:0.2 core
Pod3:0.3 core
At 11AM, it should return Pod1.
I am just not sure if there is a query that checks value relative to one another. Is there a way?