JOIN InfluxDB V3 and MS-SQL data

[steph2795]

• What Grafana version and what operating system are you using?
  V12.0.0

• What are you trying to achieve?
  I want to join data from an InfluxDB v3 DB with SQL query and data from MS-SQL and display multiple series with respect to their id and have their description in the legend.
  

  

• How are you trying to achieve it?
  Using INNER JOIN transformation
  

  

• What happened?
  The join is made correctly
  

  
  
  
  

• What did you expect to happen?
  I expected to have multiple series (with respect to their id) and instead of “_value” name, I would like to display the description of the serie.

I tried to change the display name with “${__field.labels.description}” but it doesn’t work and do not fix the multiple serie issue.

Any idea ?

Regards
Stéphane

[steph2795]

Ok I added an Partition by values transformation

And with the Display name : ${__field.labels.description}
it works

Regards
Stéphane