Convert result value to field, to match tables

Grafana Time Series Panel
1

hi, I have the same problem, but I cant match my key fields, cause from one data source I get the value of the filed am looking for, but in the other data source I get the results of the fromula I use in the other data source, I mean (like a table):
--------------------------------Last Value
Field Requested 1------- 97
Field Requested 2------- 98
Field Requested 3------- 99

Then in my other data source I get :

------------------------node 1-----------------------node 2----------------------- node 3
string ----------Field Requested 1------- Field Requested 2 -------Field Requested 3

You get my problem now_? as this is not a time series I can not convert from series to row neither.

I need to convert that result in the second data source in Fileds and then I can match it using a join transformation

2

@migb A bit confusing

  1. Why do you have it tagged as Time Series Panel, if there is no time data?
  2. What version of grafana?
  3. What data sources are these?

the following data is confusing also

--------------------------------Last Value
Field Requested 1------- 97
Field Requested 2------- 98
Field Requested 3------- 99
3
  1. Why do you have it tagged as Time Series Panel, if there is no time data?/ because there is no a transformation for something like this, the only option is getting time series, but please suggest a better tag
  2. What version of grafana?/ version 9.0.7
  3. What data sources are these?/influx

the data I have showed is very simple, just an example, that is a table first one , two columns, four rows.
Second one the opposite , two rows, four columns

4

what are the column names of the first table?

From the below sample it is impossible to parse that out

--------------------------------Last Value
Field Requested 1------- 97
Field Requested 2------- 98
Field Requested 3------- 99

Same with this one? where are the four columns?

------------------------node 1-----------------------node 2----------------------- node 3
string ----------Field Requested 1------- Field Requested 2 -------Field Requested 3
5

this is an specific example :

Field Mean
AB:v 23
BC:v 41
CA:v 76

do you understand the fileds? to give you the orher table, otherwise I can send you an screenshoot

1 Like
6

here is the second one :

referenceTags.0.index referenceTags.0.value referenceTags.0.referenceTag referenceTags.1.index referenceTags.1.value referenceTags.1.referenceTag referenceTags.2.index referenceTags.2.value referenceTags.2.referenceTag
1 23 AB:v 2 41 BC:v 3 41 BC:v
1 Like
7

are you using influxQL or flux to query the data?

8

am using influx to query the data

9

there are only 2 options for querying

influxQL or flux

there is no influx query language

10

am using influxQL to query the data