Problem with Expression

Grafana
,
1

Hi,

I have created a dashboard using infinity datasource. I have value from 2 queries as below,

  1. “where “Month” == ‘Jan’ | pivot count(“Month”)”
  2. “where “Month” == ‘Dec’ | pivot count(“Month”)”

These two queries are returning the numbers and I am using “stat” visulization to show the numbers. Now I want show the percentage or sum of these two numbers. So I used Expression in grafana and added Math expression $A + $B or ($A/$B)*100. But this is returining no value.

Please help me here to do it in right way to get the number.

2

Instead of expression math what if you tried out transformation create new field calculation option and sum them there

3

image
image1699×896 40.3 KB

image
image1692×920 57.4 KB

Still the sum doesn’t show as the values are appearing from 2 different queries for same panel even after using transfermation.