GROUP BY time wont work - is it issue with timestamps value in db or in the reading it? (im not sure)

1

got headache, it seems to be right but clearly it isnt…why?

SELECT value FROM n_franluft limit 10; gives me this…3sec interval storage…

SELECT “value” FROM “autogen”.“n_tilluft” WHERE $timeFilter gives me readings fine…

SELECT “value” FROM “autogen”.“n_tilluft” WHERE time >= now() - 1h GROUP BY time(10s) gives me error
“InfluxDB Error: GROUP BY requires at least one aggregate function”

"SELECT mean(“value”) FROM “n_tilluft” WHERE time >= now() - 3h GROUP BY time(5m) fill(null)" gives me
“InfluxDB Error: unsupported mean iterator type: *query.stringInterruptIterator”

2

Hello @sar55,
Hmm I’m not sure. That last query looks right.
Can you verify that:
Your value field type is int or float? and not a string?
Can you verify that you have data within the last 3 hours?
Can you calculate the mean without the group by?
Thank you

3

ah… thanks… looks like this…
bild

… how can i change from string to float?

4

Hello @sar55,
There isn’t a way to do this with influxql see:

However you change them with Flux.

Flux is available in 1.8+ (although I’d recommend upgrading to 2.0-r.c)