# Visualizing the average of the sums
**URL:** https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614
**Category:** Kibana
**Created:** [September 6, 2018, 4:57pm UTC](https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614 "2018-09-06T16:57:18Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@DidierB](https://discuss.elastic.co/u/DidierB)
#### Post date: [September 6, 2018, 4:57pm UTC](https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614/1 "2018-09-06T16:57:19Z")
Hello,
I have a "probe" that is doing many API calls to get, every ten minutes or so, some metrics from a service.
So around the time T (but not exactly T), I have one hundred events indexed that look like this:
First run:
{ "time":"2018-09-06T18:45:02", "service name": "nas1", "volume": "vol1", "size": 112351341 }
{ "time":"2018-09-06T18:45:05", "service name": "nas2", "volume": "vol1", "size": 11251341 }
{ "time":"2018-09-06T18:45:29", "service name": "nas3", "volume": "vol1", "size": 1128351341 }
{ "time":"2018-09-06T18:46:06", "service name": "nas3", "volume": "vol2", "size": 192351341 }
Second run, ten minutes later:
{ "time":"2018-09-06T18:55:02", "service name": "nas1", "volume": "vol1", "size": 112351340 }
{ "time":"2018-09-06T18:55:08", "service name": "nas2", "volume": "vol1", "size": 11251451 }
{ "time":"2018-09-06T18:55:23", "service name": "nas3", "volume": "vol1", "size": 1128351342 }
{ "time":"2018-09-06T18:56:01", "service name": "nas3", "volume": "vol2", "size": 192351869 }
My goal is to create a visualization (horizontal bars) of the total size of volumes, per "service name". If the time span of the dashboard is large enough and holds multiple data about one same "service name", then only the maximum is displayed.
/EDIT/ or the latest value, or the average, etc. The problem is when I do the sum, I need to have only one run to have accurate results and I the dashboard user can change the time span of the dashboard as he wishes and so get wrong results.
I didn't a find a way to do it in Kibana (we have 5.5.0).
Can you help me?
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [September 7, 2018, 7:57pm UTC](https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614/2 "2018-09-07T19:57:14Z")
Hi there,
Could I ask to clarify a few things?
Are you saying that you want each bar in the bar chart to represent a single volume, e.g. `vol1`, `vol2, with the sum of all`size`fields for the related documents, but only for those with unique`service name`values? And if there are duplicate`service name`values, you want to ignore all duplicates except for the one with the highest`size` value?
So in this example:
```auto
{ "time":"2018-09-06T18:55:23", "service name": "nas3", "volume": "vol1", "size": 1128351342 }
{ "time":"2018-09-06T18:56:01", "service name": "nas3", "volume": "vol1", "size": 192351869 }
```
You'd want to ignore the second document, and only include the first document in your visualization, since 1128351342 is greater than 192351869. Is that correct?
Thanks,
CJ
---
### Author:  [@DidierB](https://discuss.elastic.co/u/DidierB)
#### Post date: [September 10, 2018, 6:51am UTC](https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614/3 "2018-09-10T06:51:18Z")
Hello,
I want each bar to represent the total of all volumes size fields (so the "volume" do not appear in the bar and the bar as a "service name" label).
Since the probe is making regular checks, if I do this the simple way, the sum may vary depending of the time span of the dashboard. That's my problem. So I need to do, for example, the average of the "service name" "volume" "size" of each run of the probe.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 8, 2018, 6:53am UTC](https://discuss.elastic.co/t/visualizing-the-average-of-the-sums/147614/4 "2018-10-08T06:53:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.