Unable to join Time Series data with reference data from another table

Grafana Dashboards
1

I have created a Dashboard with 2 panels:

  • One with my time series data in a table
  • One with my reference data

I add a new panel and choose the 2 panels from the Dashboard Data Source and place my time series panel first. I add a transformation to rename the relationship field similar to that used in the reference data panel.
I add a transformation to perform a JOIN (none of the types do anything) and choose the common field. Nothing happens.
I have tried all the types, but nothing happens.
What am I doing wrong?

Table 1:
Cust_ID | @timestamp

Table 2:
Cust_ID | Contract_Type

Join by Field I choose Cust_ID, but nothing gets added…

2
  • Double/triplecheck that the data types are the same. Cust_ID “1” will not match to Cust_ID 1 (Integer vs. string)
  • Double/triplecheck that there are overlaps in values and that your JOIN type is the right semantics for your case
3

what is your datasource for each queries? mysql? postgres? ms sql

4

Thanks for suggestions, but still no luck.

  • Columns are definately String (I even added transforms to both tables for good measure to convert to string, but still nothing)
  • There are definately matching records in both; I also tried all the JOIN types, but nothing appears (not sure is there is an Apply option, or if I need to save first or do something else for the merged columns to appear?)
  • Data is coming from Elasticsearch (using the Elasticsearch connector)