Hello everyone!

I’m trying to create a dashboard with math expression calculated from several queries - Geneva metrics.

I have 5 Geneva metrics (A, B, C, D, E). All of them have the dimension “region” with 3 possible values.

For all of these metrics, I first perform a Reduce operation to calculate sum for a given time range with Mode “Replace Non-numeric values” with 0.

Then I perform Math expression :

(A_Sum + B_Sum) / (A_Sum + B_Sum + C_Sum + D_Sum + E_Sum).

First problem I have, is that metrics C, D and E not always have values for all regions (this is expected). And if I have a metric that has value only in 2 (out of 3) regions, then the whole expression will have in result value only for these 2 regions, even if the rest of the metrics have values for all 3 regions.

My expectation would be, that values for the missing region would fill with 0 and the whole expression would have values for all 3 regions.

Version: Grafana v9.5.19

Data source: Geneva