I record several data points (> 20) using various measuring systems and save them in an InfluxDB. Each date point is a time series with different time stamps and measured values. I record the measured values every second and now I would like to downsample all to 5 minutes. I found the following TICKscript example:
stream |from() .database('telegraf') .measurement('cpu') .groupBy(*) |window() .period(5m) .every(5m) .align() |mean('usage_idle') .as('usage_idle') |influxDBOut() .database('telegraf') .retentionPolicy('autogen') .measurement('mean_cpu_idle') .precision('s')
Here the mean is only formed for time series ‘usage_idle’.
What is an appropriate syntax to do this for all time series? mean (*)? Using wildcard …?
I read on the Internet that this is not possible. A task has to be created for each time series and each measurement, which I cannot quite believe.
What would be an alternative approach to downsampling all time series?
Many thanks and regards,