Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Suppose I have a measure having 3 buckets. 100k to 200k , 200k to 500k , 500k to 1M. How do I take a average of the measure based on buckets ? I.e, Average(Measure) where bucket = 100k to 200k ? .
I would need to plot this data for a dimension. So, instead of bucketed measure, I would need mean of the bucketed measure over the dimension.
Are the buckets kown ahead of time?
Yes. Thanks
Hi Vamsi,
If you happen to have the buckets in the script, I guess you can use aggr to achieve what you are looking for.
Hope that helps,
Carlos