I am bit new to kibana.
Till now using fields i was able to bulid my visualization and dashboard. But now my requirement is to group fields and show it in PIE chart which i feel it needs some advance query knowledge, which i have never done.
My requirement is like below: I have multiple entries like below
It has entries which ends with month and year.
In my pie chart I need to show only 3 slices ABC, XYZ and QWE, however when i try to do it shows 9 slices.
Can someone point me to the right direction, how I can write query to build right visualization as per the requirement.
Appreciate all your help.