Hello.
I have the next field
"purchasePlanRowItem_okei_code": [
"168",
"168",
"168",
"168",
"168",
"168",
"876"
],
This is array.
When I create pie chart visualization, I turn Split Slices, Aggregation - Terms, Field - purchasePlanRowItem_okei_code. And turn Slice Size, Aggregation - Count.
As result, I view chart divided into two parts. The first part is called the 168, the second part is called the 876. However, the first part of the Count is equal to one, the second part of the County is equal to one. Those, all Count is two. But my field contains array with seven values, but no two. I want to get a chart: The first part is called 168 and it Count is six, the second part is called the 876, and it is equal to one Count.
How I can do it?