Here is an example of what i mean and reason i decided to revisit this topic | stats avg(eval(round(TX,1))) as avg1 avg(TX) as avg2 output   ... View more

The issue with doing it this way is you're rounding before you average it. This works if you already have values that need to be rounded and then you average that. I used values(eval(round to  round and aggregate into mv for unique values and it works well. I have not been able to find a way with stat, operation and round because it seems like eval needs to go after stats operation which defeats the purpose of a the average.   I could be missing something so if anyone found a way please post as that would save me an extra line almost every time i write a dashboard.   ... View more