Is there a way to represent/calculate the following for y axis :
sum = 0;
for all items in the index :
if condition 1 : then sum = sum+ m
if condition 2 : then sum= sum + (1.3m)
if condition 3 : then sum = sum + (1.5m)
return sum;
where m is a numeric field in the index used.
And this should calculate sum for all the independent filters in split series.
Over x axis I have aggregation of Date Histogram.