Can't do basic division with my metrics

Grafana Dashboards
1

Hi, I am trying to divide Query A by Query B using my cloudwatch metrics.

Query A gives me 142, and Query B gives me 151.
On the side panel, the calculation is Total

Query A: (count(max(aws_alb_response_time_average)<10))
Query B: count(max(aws_alb_request_count_per_target))

I have tried dividing using Math Expression, but it says “failed to read data from query B: input data must be a wide series but got type not (input refid)”.

I have also tried using the ‘Add field from calculation’ transform and doing binary operation but it does not show any data.

the Type is Both
I dont get error if I change Type to Instant, but it still shows No Data

how can i get a simple answer?

2

Use CloudWatch math, so CloudWatch calculates that operation (not Grafana). Example how to use CloudWatch math in Grafana:

3

Im using prometheus as a datasource so I cant exactly set an ID for each of my metrrics, hence using $A and $B

4

Prometheus also supports division operator:

5

this doesnt address non-instant vectors - do you know if there’s any hope for my case?

i thought i can do division on my count metrics (which act as scalar values) and simply get 142/151