topN query based on range of values of dimension


I am trying to achieve query having dimension like amount which will have range of values in of dimensions.

For example :

Dimension : - Amount

Now amount interval can be :

0-100 , 101-1000, 1001-10000,10001-100000

Result expecting like this : count of any dimension in range of other dimension


count 40 15 19 11

range 0-100 , 101-1000, 1001-10000,10001-100000

Thanks in advance,


Hi Aman, is it possible to do this bucketing at ingestion time? So you can create these buckets when you index data. If not, you can take a look at the dimension extraction function: