Separate results of muti Query in Business Text (Separate {{{json @root}}} )

Grafana
,
1

With the business Text plugin I am trying to get the results of multi query into dynamic text to show counter and a global state

I don’t know how to separate the {{{json @root}}} ?
I have 2 query : first for the state, second for counter in & out

I tryied with
let Etat = data.series[0].fields[0].values[0];
let Incount = data.series[1].fields[0].values[0];
let Outcount = data.series[1].fields[1].values[0];

But I cant find any example with real query that are decomposed appliqued this plugin

So I am trying different typo because I don’t know at all what to do …

the {{{json @root}}} give all result between { } , it is very ugly, I would like to separe and to delete this {} too :

code 2
code 21661×763 68.9 KB

code
code1685×685 64.6 KB

2

probably best to describe your requirement instead of your actual implementation. otherwise we will be trying to fix your implementation which could be wrong

so in plain english and with no technical implementation lingo what are your requirements by also giving a snippet of your data not as an image but actual text we can copy pref as csv or json

1 Like
3

@SunrakuBzh Please read documentation, which has examples how to work with multi-queries.

You can’t mix scripts and body like in your examples for security reasons.

4

I would like to show value that I get with 2 queries, the first is a string, the second is 2 dint.

With ‘text plugin’ I can’t do query, so I tried with ‘business text plugin’ but with the ‘Stat plugin’ it is working well