This message was deleted.

yes, you are correct but you do not have to limit yourself to one aggregator. say you have a field called

age

and you want to be able to compute

min

,

max

, and

avg

later on...

well, for the

avg (arithmetic mean)

you kinda can if you also add a new metric for

count

and

sum

but yeah, it's not possible to get avg directly from the rollup. you can, however, make good assumptions, using thetasketch

you would define 3 metrics

min_age

,

max_age

and

sum_age

. Then you could do

MIN(min_age) as min_age

,

MAX(max_age) as max_age

,

SUM(sum_age) / SUM(count) AS avg_age

you can use theta-sketch, then use DS_QUANTILES_SKETCH to get some quantiles back

note that I am assuming that you are also ingesting a

count

metric (you would be crazy not to do it with rollup)

yeah, I think once you enable rollup, the count will appear in the metrics list

if you are using the console wizard then it will put count in the the metrics list when you click to enable rollup, but if you are not using the console then you should make sure to add it yourself

I see. Yes, you are right, we are using the console wizard. Thank you for the explanation!

Nice. Please remember that the wizard is just a tool to help you! It has a handy shortcut to convert a dimension to a metric but that will only create 1 metric. if you want 3 like I outlined above you have to click

Add metric

and add it your self.

sure, will do. Thank you, Vadim!