How to do math calculation from two JSON columns value

Grafana Dashboards
,
1

Hi Guys,

I’m able to get the value from Rest API call with Infinity plugin as data source for Grafana.

E.g. able to display value 12 as “TotalGrouop” on dashboard
able to display value 1000 as “TotalAmount” on dashboard as well.

My question, how to perform the math calculation between this two values?

AvgAmount = TotalAmount/TotalGroup = 1000/12

=======JSON file example===========
{
“TotalGroup” : 12,
“TotalAmount” : 1000
}

Thank you.

2

welcome @bestvincent

image
image818×605 27.6 KB

or UQL jsonata (UQL)

parse-json
| jsonata "$map($, function($v, $i, $a) { $v.TotalAmount/$v.TotalGroup})"
3

Actually you don’t need UQL for writing JSONata. Simply select backend parser which is more powerful than UQL, then in the root selector you can write JSONata and get the data visualized.

image
image3100×1654 240 KB

or

$map($, function($v) { return { 
     "output": $v.TotalAmount / $v.TotalGroup
} })

image
image3142×1640 259 KB

4

@ yosiasz
Thank you, the transform method method worked for me. Although I couldn’t make UQL work.

@ yesoreyeram
Both methods worked for me!

Thank you guys help.

1 Like
5

Additional question:

What’s the best/easiest way to change the default Query name (e.g. A, B, C, D …) on dashboard?

I know we can configure override to replace fields Display Name.

Thanks.