Hello, is it possible to build a query that would return values in the following manner:

{

dimension_value_1: {

interval_1: {

aggregation_1: metric

},

interval_2: {

aggregation_1: metric

}

},

dimension_value_2: {

interval_1: {

aggregation_1: metric

},

interval_2: {

aggregation_1: metric

}

},

dimension_value_n: {

interval_1: {

aggregation_1: metric

},

interval_2: {

aggregation_1: metric

}

}

}

``

Basically, a topN or GroupBy over a single dimension, with aggregations over multiple custom intervals.

Currently, I am performing a topN query over each different custom interval, and pairing the returned values to compute a different aggregate. However, if Druid was able to compute the multiple interval aggregates in a single query and do the pairing, it would help the performance of my operation a lot; the cardinality of the dimension is very high.

Thank you in advance for any help.