i am a bit new to elastic queries.
i have a requirement like this..i have a field "X" which contains values like a,b,c,d,e.... . and another field "Y" which contains values like r,s,t,u,v (here i know values in Y and that too only 6 types) but in X i don't know how many types of values are there.
i want to write a query which will return me the count of types of Y values for each type of X .
any help ll be appreciated!!