Sum of max value

I have data coming once an hour

01am connection - 10, region1
01am connection - 20, region2
01am connection - 30, region3

02am connection - 01, region1
02am connection - 40, region2
02am connection - 50, region3

now what I need is max of all region per day which is easy to get
region1 - 10
region2 - 40
region3 - 50

what I need is sum of that max = 10+40+50 = 100

how do I achieve this in visulization.

I have try sum of max bucket but not working.

Hey @elasticforme,

What version of Elasticsearch / Kibana are you using?

Can you share the settings that you used to try to create the visualization?

Using the sample flight data that comes with Kibana, I'm able to find the max flight distance per origin per day, and then sum those maximums per day. Does this look like what you're looking for?

Screen Shot 2021-03-02 at 2.31.38 PM

Screen Shot 2021-03-02 at 2.29.53 PM

Brian

1 Like