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.