Hi ,

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

Thanks ,