Calculate max value of each http code

Hello there,

I have a question about visualization here. First, this is an overview of my panel

as you can see there are 3 HTTP codes at 11:00 and I used breakdown by http_status field. So, the question is how if I want to sum the max value of each HTTP code there without using breakdown? In other words, I want to make it become 1 bar without being separated by the HTTP code and the bar showing 10k counts.

Is it possible? If yes, is there any formula I can use to achieve this in the Vertical axis?

fyi, this is my case If it's applied in elastic query and I'm using kibana 7.17
image

Thank you

Hi @yuswanul

I think what you are looking for can be achieved with the "collapse by" feature added in Lens since 8.3.0: [Lens] Add collapse fn to table and xy chart by flash1293 · Pull Request #131748 · elastic/kibana · GitHub

In the old version 7.17 I do not think that can be achieved.

alright. thanks for the insight. I'll try that to makesure