Please how should be looked select statemnt if I need to calculate the sum each day for constant time interval, e.g. from 6:00 to 20:00 hours.
SELECT sum(“value”) / 60000 FROM “m_power” WHERE $timeFilter GROUP BY time …
Thank’s for help
you simply can’t do that with InfluxQL, there is no concept of day or hour.
The only option is to add that data as a tag, so you can filter on it (ie: add the hour tag to your data, with values like 15-16-20-etc).
If you use Flux there are some functions that allow you to play around with the timestamp and probably achieve what you are asking
