Calculate percentage based on other aggregation


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. :slight_smile:

Screenshot 2023-05-25 at 12.21.25 PM

OpenSearch/OpenDistro are AWS run products and differ from the original Elasticsearch and Kibana products that Elastic builds and maintains. You may need to contact them directly for further assistance.

(This is an automated response from your friendly Elastic bot. Please report this post if you have any suggestions or concerns :elasticheart: )