'Join by field' data jumping around in table

Grafana
1

Hi,

I got a table in my grafana dashbaord and I am using the ‘Join by field’ transformation to combine 2 databases into 1 table. All data with the same EID now gets put into 1 row. Data is coming from Timestream.

Now the one problem I am running into is that the values from one table keep jumping around to either side of the table and this also messes with the order of the data. (see GIF)

This jumping only happens when auto refresh is on!

test 2
Sorry, the gif is kinda unreadable

I’m guessing this is just a grafana issue and it might be unfixable, but if anyone knows a solution, please let me know here.

both queries:

SELECT
  "EID",
  "Date (Teltonika)" AS "Date Machine",
  "Time (Teltonika)" AS "Time Machine"
From "Zohry711_database"."Zohry711_bale_table"
ORDER BY time DESC
LIMIT 1000


SELECT
  "Date (Android)" AS "Date Weighbridge",
  "Time (Android)" AS "Time Weighbridge",
  "EID",
  CAST("Bales" AS INT) AS "Bales",
  CAST("Weight" AS INT) AS "Weight",
  CAST("Weight per Bale" AS DOUBLE) AS "Weight per Bale"
From "Zohry711_database"."Zohry711_android_table"
ORDER BY time DESC
LIMIT 1000