Hello All,
My goal is to limit the results based on a percentage of a sum aggregation. I will try to clarify it with an example.
{ "name": "A", "value": 10 }
{ "name": "B", "value": 20 }
{ "name": "B", "value": 35 }
{ "name": "A", "value": 15 }
{ "name": "C", "value": 15 }
{ "name": "A", "value": 10 }
{ "name": "C", "value": 5 }
{ "name": "A", "value": 10 }
{ "name": "D", "value": 15 }
{ "name": "A", "value": 30 }
{ "name": "E", "value": 1 }
(...)
Aggregating the data above,
{ "name": "A", "value": 70 }
{ "name": "B", "value": 60 }
{ "name": "C", "value": 50 }
{ "name": "D", "value": 45 }
{ "name": "E", "value": 40 }
(...)
Imagine that the sum of all values is equal to 640
I would like to show the items that together they represent 20% (or a bit more) of 640
640 * (20/100) = 128
So, the result that I would like to have is:
{ "name": "A", "value": 70 }
{ "name": "B", "value": 60 }
I will appreciate any thoughts.
Cheers,
Paulo