Hi,
I have a problem that I need to group by X and Y and aggregator on Z and I need
to paginate on the results.
The results aren't flat they are in hierarchy so how to flat the results so we
can paginate on them for each combination of X,Y like:
Computers, Computer Laptops, 5.684790733920929E10
Computers, PE_Server, 1.1207993365851181E10
Computers, Monitors, 1.2723246848002455E9
Data Communications Hardware, Datacom Hardware, 6.3539691650598495E10
>From the sample of the results:
"X":{
"buckets":[{
"val":"Computers",
"count":981466,
"Y":{
"buckets":[{
"val":"Computer Laptops",
"count":391064,
"sum":5.684790733920929E10},
{
"val":"PE_Server",
"count":218148,
"sum":1.1207993365851181E10},
{
"val":"Monitors",
"count":122176,
"sum":1.2723246848002455E9}]}},
{
"val":"Data Communications Hardware",
"count":428230,
"Y":{
"buckets":[{
"val":"Datacom Hardware",
"count":428230,
"sum":6.3539691650598495E10}]}},
{
"val":"Leasehold Improvements",
"count":33677,
"Y":{
"buckets":[{
"val":"Leasehold improvements",
"count":33676,
"sum":1.6308392462957385E12},
{
"val":"Electrical & Air Conditioning",
"count":1,
"sum":4505.0}]}},
{
