Hi, Can some one please help in the below scenario.
I have the data 1000 records with each record is having 10 fields.
I want to display the table with number of output fields.
one out put field calculation is :
field 3 = 12 or 13 or 14 and filed 4 = 1 or 2
I am using sum bucket metric aggregation and filters, It is not giving correct results in the combination.
when i use field 3 = 12 or 13 or 14 in one filter and by adding another filter for field 4=1 or 2
it is giving the total records for each filter instead of evaluating the whole condition