Hi,
I am using data table to display the API response for 200, 4xx and 5xx errors.
I need to calculate percentage of 4xx and 5xx errors based on the grand total count of all response types. Any idea on how to do this on OpenSearch which doesn't support Kibana Lens and Canvas?
The grand total and the 200 columns shown in the image below are individual aggregation.
So basically I need to count percentage by taking result from aggregation (grand total) divide by aggregation (200).
I am new to Kibana data table, kindly advise on how to achieve this.