Hello to you all.
I am designing a IoT solution in the Cloud with an Influxdb (to hold the time series data) and Grafana (to visualize it). But I want to be able to analyse also static data in the same grafana dashboard, such some aggregations, machine descriptions, product building receipts, etc.
I know that I can integrate static data in Influxdb with sql.from() function, but I think it will lead to performance problems, since I think is too much information. Other option is to store the aggregated data in a separate SQL database and use it as another source for Grafana, though I do not think I could integrate it with the time series data.
So, What is a better approximation? Which are the best practices to integrate time series data and aggregated data in the same dashboard?
Thanks in advance!