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 https://github.com/influxdata/influxdb/pull/9632

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: