ROUND a MEAN value with a given amount of decimals?

I can’t find in the documentation how i’m supposed to do something like this :

SELECT ROUND(MEAN(value), 2) ...

to get a value like 1.79 instead of 1.7925925925925925.

Try round(mean(value)*100)/100 …

See also Implement floor, ceil, and round functions by Ahmah2009 · Pull Request #9632 · influxdata/influxdb · GitHub

Regards,

Antony.

Thanks for the tips Antony !

Too bad the ROUND function isn’t like the SQL one, it would be a lot more readable :slight_smile: