Filter a Query from Results of Another Query

[Chris Beyers]

Grab the namespaces we want to collect data on:
sum(kube_namespace_labels{label_machineset="default"}) by (namespace)


Inject Into These Results:

kube_resourcequota{resource="limits.cpu",type="hard",namespace={only namespaces from previous query}}



How do I go about filtering the resourcequota totals from only namespaces returned in first query?

Much thanks!

Chris

[Bryan Boreham]

The trick is to do a "join", which in PromQL terms can be an arithmetic expression.

Since the value of the first set of series is always 1, you can join by multiplying the two together.