# Sum aggregation : CSV file parsed using ELK, looking for a way to get a sum value of CPU, Memory & Disk utilized across the cluster

**URL:** <https://discuss.elastic.co/t/sum-aggregation-csv-file-parsed-using-elk-looking-for-a-way-to-get-a-sum-value-of-cpu-memory-disk-utilized-across-the-cluster/85913>\
**Category:** Elasticsearch\
**Created:** [May 16, 2017, 11:08am UTC](https://discuss.elastic.co/t/sum-aggregation-csv-file-parsed-using-elk-looking-for-a-way-to-get-a-sum-value-of-cpu-memory-disk-utilized-across-the-cluster/85913 "2017-05-16T11:08:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guru\_W](https://avatars.discourse-cdn.com/v4/letter/g/f05b48/32.png) [@Guru\_W](https://discuss.elastic.co/u/Guru_W)\
**Post date:** [May 16, 2017, 11:08am UTC](https://discuss.elastic.co/t/sum-aggregation-csv-file-parsed-using-elk-looking-for-a-way-to-get-a-sum-value-of-cpu-memory-disk-utilized-across-the-cluster/85913/1 "2017-05-16T11:08:01Z")

</div>

I am new to ELK, looking for help.

I have csv data of Virtual machines Inventory in a csv file, while visualizing the data.

Can anybody help me with getting sum value of CPU, Memory and Disk used?

Example:

![](https://us1.discourse-cdn.com/elastic/original/3X/3/9/39da0563501ff256b858322794812f6005cb1b91.png)

Error:

![](https://us1.discourse-cdn.com/elastic/original/3X/c/f/cf7ba9ac975d1a0edc78feaed6c1196559aa0d57.png)

---

<div class="post-metadata">

**Author:** ![Guru\_W](https://avatars.discourse-cdn.com/v4/letter/g/f05b48/32.png) [@Guru\_W](https://discuss.elastic.co/u/Guru_W)\
**Post date:** [May 18, 2017, 11:35am UTC](https://discuss.elastic.co/t/sum-aggregation-csv-file-parsed-using-elk-looking-for-a-way-to-get-a-sum-value-of-cpu-memory-disk-utilized-across-the-cluster/85913/2 "2017-05-18T11:35:25Z")

</div>

Anyways I found the solution.

Changed the data type using "mutate" as to "integer" while parsing the data through logstash.

Sum aggregation works fine now 🙂

![](https://us1.discourse-cdn.com/elastic/original/3X/9/6/96f84536d632a1dcf5a5477f6da6a802813aacd6.png)

![](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4b2cf40b57bbdd659a5b8b756d834b27f0093627.png)

---

<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:** [June 15, 2017, 11:35am UTC](https://discuss.elastic.co/t/sum-aggregation-csv-file-parsed-using-elk-looking-for-a-way-to-get-a-sum-value-of-cpu-memory-disk-utilized-across-the-cluster/85913/3 "2017-06-15T11:35:54Z")

</div>

Closed on June 15, 2017, 11:35am UTC

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