How to merge results from multiple data sources to perform transformation?

I have 2 Data source : InfluxDb and Postgress SQL .In Real-time ,Want to merge result and transform before displaying in the dashboard

Function such as Filter certain data such as duplicate compare and then select the desired output

Hi,
you could for example make a separate process/program which obtains the data from your different data sources and pre-processes the data obtained in the way you need and then feeds the result to grafana via websockets or http request as outlined here:
https://community.grafana.com/t/how-to-connect-streaming-data-source-to-websocket/54927/4
The grafana configuration is roughly described here:
https://grafana.com/tutorials/stream-metrics-from-telegraf-to-grafana/
in the section " Create dashboard with streaming data"
I made some trials and it works, but haven’t yet gone into fine tuning this method.
Have a great day,
Olivier

1 Like