I use Grafana for create a dashboard on my Prometheus metrics.
I have two metrics.
1- number of request named channel_total that has channel name as label
2- number of failed named as channel_failed that has channel name as label
I create two queries.
1 = sum(channel_total ) by (channel)
2 = sum(channel_failed ) by (channel)
and I want two have a table to show channel, total , failed as bellow
channelname | number of request | number of failed
channel1 | 1000 | 10
channel2 | 5000 | 660
I used join by field but in range format in query it is so slow and I get timeout error