Create widget in dashboard to get CPU usage and limit together

I’m trying to create a new widget, so it will give me a line chart which include line of cpuLimitCores and a line of cpu core usage for each Kubernetes pod,

This apparently not working and show only 1 line (to each pod) in the chart:
SELECT max(requestedCpuCoresUtilization),max(cpuLimitCores) from K8sContainerSample WHERE clusterName = 'prod' and namespace = 'bla' and status ='Running' FACET podName TIMESERIES

any idea how to get cpu usage and limit together in the same line chart?

This query should absolutely work for what you need. I ran that in a demo environment I have here and I get the results below:

Can you share what you see if you were to look for those metrics individually?

Something like:

SELECT max(requestedCpuCoresUtilization) from K8sContainerSample WHERE clusterName = 'prod' and namespace = 'bla' and status ='Running' FACET podName TIMESERIES
SELECT max(cpuLimitCores)  from K8sContainerSample WHERE clusterName = 'prod' and namespace = 'bla' and status ='Running' FACET podName TIMESERIES

I’m curious to see the results of this.