# Divide metrics and display them in Table Visualization

**URL:** https://discuss.elastic.co/t/divide-metrics-and-display-them-in-table-visualization/138689
**Category:** Kibana
**Created:** [July 5, 2018, 10:29am UTC](https://discuss.elastic.co/t/divide-metrics-and-display-them-in-table-visualization/138689 "2018-07-05T10:29:38Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![sgarap](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@sgarap](https://discuss.elastic.co/u/sgarap)
#### Post date: [July 5, 2018, 10:29am UTC](https://discuss.elastic.co/t/divide-metrics-and-display-them-in-table-visualization/138689/1 "2018-07-05T10:29:39Z")

</div>

Hi,

I want to create a very basic visualization in kibana. I have a field in the document namely which signifies the amount of memory consumed. A watch writes data into this index every 10 minutes.

Each document in elasticsearch will have an array of instances of a cluster with memory details.  
{"memory": {  
"instance\_capacity": 4096,  
"memory\_pressure": 6  
} },  
{"memory": {  
"instance\_capacity": 4096,  
"memory\_pressure": 6  
} }

I want to see the metrics in table Visualization as follows

```
    |Cluster Name|Used Memory in MB|Capacity in MB|num_records|Average Capacity|Calculate max of sum (Capacity in MB/num_records)|
|---|---|---|---|---|---|
|threezones|108|73,728|6|4,096|12,288|
|36cabfb384b74cb29fd6db92f4e0d8e8|36|24,576|6|4,096|4,096|
|onezone|36|24,576|6|4,096|4,096|
|noli|84|55,296|6|4,608|9,216|
|3919ec0746fc443b970c0b73ba633ec0|90|202,752|6|16,896|33,792|

```

I used sum aggregation to collect 'Capacity in MB'. but since there are 6 records inserted in a period of 1 hour, i want to calculate the last column 'Calculate max of sum (Capacity in MB/num\_records)' by dividing 'Capacity in MB' with 'num\_records' for calculating the report. Can anyone have ideas how to acheive it or are there any better alternatives to calculate such metrics?

---

<div class="post-metadata">

### Author: ![Bill\_McConaghy](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bill\_McConaghy](https://discuss.elastic.co/u/Bill_McConaghy)
#### Post date: [July 5, 2018, 2:27pm UTC](https://discuss.elastic.co/t/divide-metrics-and-display-them-in-table-visualization/138689/2 "2018-07-05T14:27:18Z")

</div>

You could use a scripted field to do this calculation I think.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 2, 2018, 2:27pm UTC](https://discuss.elastic.co/t/divide-metrics-and-display-them-in-table-visualization/138689/3 "2018-08-02T14:27:18Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.