Is it possible to take the day of the week from the field time? I would like InfluxDB to only return the values from Monday to Friday.
For example: select mean(value) from data_x where week(time) not in (‘saturday’,‘sunday’)
Is it possible to take the day of the week from the field time? I would like InfluxDB to only return the values from Monday to Friday.
For example: select mean(value) from data_x where week(time) not in (‘saturday’,‘sunday’)