I am using the datasource (Infinity) to operate with .csv files that I have on an rpi5, on my rpi5 I also have a server that organizes the data from several esp32 (each one with an identifier) to take data from different sites, now, each esp32 sends data with a different time, when loading them into grafana the data from each esp32 arrives with different times (and that’s fine, it’s according to the time of the data registration).
Now, what I did was create several dashboards, each one graphing the data of an esp32, and I created one more dashboard that joins the data of the esp32 in a single graph to make the comparison of the data easier, the problem comes when I want to export the data in .csv format from grafana to process it, share it, for someone to open it in excel or however, since as the data arrives with different hours I have to download it separately but the idea is that it is all together, so I tried with the Series Joined By Time option, but I don’t get any information, I added a Join By Field transformation to the data, and I tried with the three options that it gives me, but in INNER it makes me lose data, in TABULAR I also lose data and it doesn’t synchronize it, and OUTER I don’t lose data but it leaves me empty spaces so when exporting it by applying the transformations the data has empty fields and in excel it couldn’t be processed easily (I think), I don’t know if can someone help me, thank you very much.
