I am using Azure Log Analytics as datasource
My query
InsightsMetrics
| where Namespace == "prometheus"
| where Name == "my_metric"
| extend tags=parse_json(Tags)
| extend pod_name=tostring(tags.pod_name)
| summarize val= sum(Val) by bin(TimeGenerated, 1m),pod_name
| project TimeGenerated,val,pod_name
data looks like this:
“TimeGenerated”,“pod_name”,“val”
2020-10-07 11:36:00,mypod-7d4f9dcd69-b4cms,172246
2020-10-07 11:37:00,mypod-7d4f9dcd69-b4cms,172246
2020-10-07 11:55:00,mypod-7d4f9dcd69-b4cms,172166
2020-10-07 12:57:00,mypod-7d4f9dcd69-b4cms,101341
2020-10-07 12:58:00,mypod-7d4f9dcd69-b4cms,101341
2020-10-07 12:27:00,mypod-7d4f9dcd69-b4cms,101341
2020-10-07 12:29:00,mypod-7d4f9dcd69-b4cms,101341
2020-10-07 06:57:00,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:25:00,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:54:00,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:55:00,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:28:00,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:47:01,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:59:01,mypod-5d77b45cdb-9wnjg,1738
2020-10-07 06:50:00,mypod-5d77b45cdb-9wnjg,1738
more points to follow…
I need to render line per pod name (x-axis time, y-axis value)
instead of “Values” label, I expect to see list of "my-pod"s