Hello everyone!, I have a telegraf/influxdb/grafana configuration and all the raw data received from telegraf is stored in a database called db1. I created a continuous query to write downsampled data (one point every 10 minutes) in other database (db2), my CQ is like this:
CREATE CONTINUOUS QUERY “cq_10min” ON “db1” BEGIN SELECT mean( * ) INTO db2.autogen.:MEASUREMENT FROM /./ GROUP BY time(10m), END
All the MEASUREMENT names are called the same that in db1, but the field names has changed. For example:
In the measurement cpu, what in db1 is called usage_idle, in db2 now is called mean_usage_idle.
Is there any way to remain the same field names? This is a problem for me since a want to create grafana templates that will allow me to change between databases.
What could be other solution for this kind of issues?
Thanks in advance!