# How can I add label "PromQL Query Result" that has no label

**URL:** https://discuss.prometheus.io/t/how-can-i-add-label-promql-query-result-that-has-no-label/2416
**Category:** PromQL
**Created:** [September 23, 2024, 7:36am UTC](https://discuss.prometheus.io/t/how-can-i-add-label-promql-query-result-that-has-no-label/2416 "2024-09-23T07:36:14Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![samuel.kwon](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@samuel.kwon](https://discuss.prometheus.io/u/samuel.kwon)
#### Post date: [September 23, 2024, 7:36am UTC](https://discuss.prometheus.io/t/how-can-i-add-label-promql-query-result-that-has-no-label/2416/1 "2024-09-23T07:36:14Z")

</div>

Hi, I’m new in PromQL

- I have lots of VMs, almost 300. each VM has prometheus label named “team”
- (1) I add each team’s VMs cpu usage(team A, team B, team C, …)
- (2) I add all VM’s cpu usage(team A+team B+team C+team D+…)
- (3) so I want (1) / (2) \* 100, so that make “team’s CPU usage(%) in all servers”

PromQL Query that i tested below :  
(1) each team’s VMs avg  
avg by(team) ((100 - sort(avg by (instance,team (irate(node\_cpu\_seconds\_total{team=“A”,mode=“idle”}[3m])) \* 100)))

(2) all VMs avg  
sum ((100 - sort(avg by (instance,team) (irate(node\_cpu\_seconds\_total{team!=“”,mode=“idle”}[3m])) \* 100)))

(3)  
avg((100 - sort(avg by (instance,team) (irate(node\_cpu\_seconds\_total{team=“A”,mode=“idle”}[3m])) \* 100))) / (sum ((100 - sort(avg by (instance,team) (irate(node\_cpu\_seconds\_total{team!=“”,mode=“idle”}[3m])) \* 100)))) \* 100

but, as you know,  
(2) has just value, no label… so i can’t calculate (1) / (2) because of label match problem

if i use “avg” instance of “avg by (team)” in front of (1), it’ll calculated (3),  
but that result has no label, so I can’t use it another tool(like Grafana)

So… The Question is:

How can i Add label when just use “sum”, not “sum by” in PromQL Query Result.

Thank You
