I have this raw data in Elastic:
I need first to create in Kibana a table like that one:
but the most important is that I have to create a table based on the aggregation above like the following (i'm highlighting the excel formulas to reproduce in Kibana):
Is there a way to make in Kibana the tables I need (especially the last one)?
Thank you very much