I have some test data in the DB and can select something like this:
SELECT value FROM nkktable.autogen.NKK WHERE time > now() - 1d GROUP BY position
where I get 10000 rows back, like
If I change the select to
SELECT mean(value) FROM nkktable.autogen.NKK WHERE time > now() - 1d GROUP BY time(1s),position
the result is empty. The data are created a few minutes ago with current timestamp.
What am I doing wrong?