Combining aggregations in a data table

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
v 1.3.2

Describe the issue:

In a data-table visualization for a dashboard, I need to do calculations on multiple aggregations. I have two data points - “complete” and “sellable”. I have columns that are “max” aggregations for each, is there a way to make a column that can use both of those numbers in a calculation?

Configuration:

Relevant Logs or Screenshots:

Hi @NateP
Could you share a screenshot of your data-table visualization?


Here’s the table, basically need to be able to use multiple of the metrics in a single column. E.g., calculations using max complete and max sellable. Let me know what other details would be helpful. Thanks.