I am trying a visualization where in I have to count some records based on some conditions and group by using two fields.
I am not getting how to add one more group by field and where to put where condition fields.
Below approach I have tried -
I did count (field) on Y axis.
Date Histogram aggregation on X-axis.(This is one of my group by field)
In Split Series , I am doing sub aggregation as filters and passing two fields(Field1: VALUE1 AND FIELD2 : VALUE2) on which I need to select data.
Can anyone suggest how and where I need to add other group by field and what I have done is correct approach.I have gone through few links but didnot find group by multiple field scenario
I did try with two approaches -
Time Series and Line Chart.(not sure which one to follow )
I am stuck here .Pls help