I want to plot a Timeseries of TPS of few APIs in Grafana Dashboard. But the challenge is I want to extract the URIs based on Joining 2 Queries as below.
Example :

Following query returns the identifier and URI combinations ( Value would be something else that can be ignored ) :
sum by (identifier,uri) ( custom_metric_total{identifier=~"${idenfiers}" ) 

Following query returns the URI and respective TPS :
(sum(rate(http_server_requests_seconds_count{}[1m])) by (uri))

I want to prepare a timeseries of the IDENTIFIER-URI combination ( Only URIs which exist in both results ) using the values of TPS. Main objective is to MERGE Series1 and Series2 based on URI and retrieve the Value from Series1 and Identifier from Series2.

Can someone experienced with it set me in right direction on how to achieve this through some query changes or Transforms.