# Regarding Displaying Ram in Pie chart **URL:** \ **Category:** Kibana\ **Created:** [September 28, 2017, 7:38am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075 "2017-09-28T07:38:33Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [September 28, 2017, 7:38am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/1 "2017-09-28T07:38:34Z")
Hi , I wants to display RAM(total Ram, Used ram , Free ram) through pie chart in Kibana. can anybody help me with steps Thanks & Regards Shrikant ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [September 28, 2017, 6:29pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/2 "2017-09-28T18:29:02Z")
Sure, this can be achieved through Pie chart visualization.Use the filters aggregation in a split slices bucket. You can probably have a Perhaps you could use the pie chart - "filters" aggregation in a "split slices" bucket. You would probably just have a filter for total RAM, used RAM and Free RAM then the pie chart would show you the distribution. ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [September 29, 2017, 5:05am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/3 "2017-09-29T05:05:45Z")
![Screenshot from 2017-09-29 10:34:56](https://us1.discourse-cdn.com/elastic/original/3X/d/6/d61f1b88b06d4ad7e8e3391fb8d671c205db7718.png) Thankyou for your reply As I am new to ELK . when i tried Its Showing this ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [September 29, 2017, 4:18pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/4 "2017-09-29T16:18:21Z")
> [@shrikantgulia](#): > > I wants to display RAM(total Ram, Used ram , Free ram) through pie chart in Kibana. Can you please let us know how your mappings look like? And also your filter doesn't look right. You may not be able to visualize in a pie chart what you are looking for, but it will depend on your mappings. Thanks Rashmi ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [September 29, 2017, 5:38pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/5 "2017-09-29T17:38:33Z")
![Screenshot from 2017-09-29 23:06:03](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1a3cb396c1b577e8982c608e7cf4c6f9a2134d95.png) ![Screenshot from 2017-09-29 23:06:28](https://us1.discourse-cdn.com/elastic/original/3X/0/b/0b862417c721cebd566428ac12ca366b42dd18b9.png) Thankyou for the reply The screenshot for mappings have been uploaded Thanks & Regards Shrikant ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [September 29, 2017, 6:33pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/6 "2017-09-29T18:33:29Z")
Mappings don't show the exact relevance . Do u have access to actual RAM value , Used RAM and Free RAM values in ur cluster ? Are they different fields ? You probably won't be able to use a pie chart. But you can put them next to each other on a bar chart . ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [September 30, 2017, 1:44am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/7 "2017-09-30T01:44:15Z")
What should be my mappings. Yes I was able to show them through bar chart. Pls guide me through mappings Thanks & Regards Shrikant ---
**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\ **Post date:** [October 1, 2017, 10:17pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/8 "2017-10-01T22:17:54Z")
In the mappings, each level usually defines a properties setting, which maps the keys of the document at that level to its mapping. This structure is hierarchical, which means that every level down to the leaf nodes may include properties settings for its child values. I would suggest you to read through couple of introductory links, which would give you a fair understanding of your mappings . > **[An Introduction to Elasticsearch Mapping | Elastic](https://www.elastic.co/blog/found-elasticsearch-mapping-introduction)** > > This article will give an introduction to the mapping feature of Elasticsearch. We'll define the key terms and take a closer look at what mapping is, when we specify it, how it is structured and how we can apply it to our data. [https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html) Glad you got it working through a bar chart visualization. Thanks Rashmi ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [October 3, 2017, 7:25am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/9 "2017-10-03T07:25:04Z")
Thankyou for the reply mam ![Screenshot from 2017-10-03 12:52:48](https://us1.discourse-cdn.com/elastic/original/3X/9/1/91f7ba1f940a7b5c674fd9cad0a437d7c44aa4a3.png) ![Screenshot from 2017-10-03 12:52:59](https://us1.discourse-cdn.com/elastic/original/3X/4/6/46b9181e8b93e1a06c7e874a10a96e9c989a30fb.png) ![Screenshot from 2017-10-03 12:52:54](https://us1.discourse-cdn.com/elastic/original/3X/e/6/e6a45300ade3c9384f8a826bab42a21dfca5cb1e.png) As you can see my mappings. than do i need to keep only those terms which i need under \_type field ---
**Author:** ![thomasneirynck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thomasneirynck/32/23313_2.png) [@thomasneirynck](https://discuss.elastic.co/u/thomasneirynck)\ **Post date:** [October 4, 2017, 7:27pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/10 "2017-10-04T19:27:08Z")
hi @shrikantgulia, it would be helpful if you could paste your mappings as plain text. Those screenshots are hard to work with from our end. As for using the pie-chart, those charts are generally used to show the distribution of exclusive categories. So I'm not sure how you would be able to show total RAM, but also used and free ram in a single pie-chart. You could conceivable show a pie-chart with two slices, one for free ram and another for used ram, but you will need a way to compute both so both categories are part of the same result-set. This would be possible s if you had different documents in your index, one for the used ram, the other for the free ram. Then you can easily filter on each, summing the values for those fields by type. ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [October 5, 2017, 4:45am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/11 "2017-10-05T04:45:34Z")
"system": { "properties": { "core": { "properties": { "id": { "type": "long" }, "idle": { "properties": { "pct": { "type": "float" } } }, "iowait": { "properties": { "pct": { "type": "float" } } }, "irq": { "properties": { "pct": { "type": "float" } } }, "nice": { "properties": { "pct": { "type": "float" } } }, "softirq": { "properties": { "pct": { "type": "float" } } }, mappings after the command (GET (indexname)/\_mapping) ---
**Author:** ![shrikantgulia](https://avatars.discourse-cdn.com/v4/letter/s/c68b51/32.png) [@shrikantgulia](https://discuss.elastic.co/u/shrikantgulia)\ **Post date:** [October 9, 2017, 7:40am UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/12 "2017-10-09T07:40:21Z")
Hello Rashmi, I read about mappings in the tutorial & its my mapping for my metricbeat logs { "infinia-restaurant-demo": { "mappings": { "doc": { "properties": { "@timestamp": { "type": "date" }, "beat": { "properties": { "hostname": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } }, "name": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } }, "version": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } } } }, "metricset": { "properties": { "module": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } }, "name": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } }, "rtt": { "type": "long" } } }, "system": { "properties": { "cpu": { "properties": { "cores": { "type": "long" }, "idle": { "properties": { "pct": { "type": "float" } } }, "iowait": { "properties": { "pct": { "type": "float" } } }, "nice": { "properties": { "pct": { "type": "float" } } }, "softirq": { "properties": { "pct": { "type": "float" } } }, "steal": { "properties": { "pct": { "type": "float" } } }, "system": { "properties": { "pct": { "type": "float" } } }, "user": { "properties": { "pct": { "type": "float" } } } } }, "fsstat": { "properties": { "count": { "type": "long" }, "total\_files": { "type": "long" }, "total\_size": { "properties": { "free": { "type": "long" }, "total": { "type": "long" }, "used": { "type": "long" } } } } }, "load": { "properties": { "1": { "type": "float" }, "5": { "type": "float" }, "15": { "type": "float" }, "norm": { "properties": { "1": { "type": "float" }, "5": { "type": "float" }, "15": { "type": "float" } } } } }, "memory": { "properties": { "actual": { "properties": { "free": { "type": "long" }, "used": { "properties": { "bytes": { "type": "long" }, "pct": { "type": "float" } } } } }, "free": { "type": "long" }, "swap": { "properties": { "free": { "type": "long" }, "total": { "type": "long" }, "used": { "properties": { "bytes": { "type": "long" }, "pct": { "type": "float" } } } } }, "total": { "type": "long" }, "used": { "properties": { "bytes": { "type": "long" }, "pct": { "type": "float" } } } } } } }, "type": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } } } } } } Pls guide me next what should i do A help would be really appreciated. Regards Shrikant ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [October 11, 2017, 6:47pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/13 "2017-10-11T18:47:06Z")
From what I can see you are using metricbeat data for this. There is no way to do a pie chart with the way the data is reported/structured in metricbeat as it is set up to display the evolution over time of the data. You can have something like this, which is alreadu part of the Metricbeat sample dashboards ( [https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-sample-dashboards.html](https://www.elastic.co/guide/en/beats/metricbeat/current/metricbeat-sample-dashboards.html) ) : ![memory_metrics](https://us1.discourse-cdn.com/elastic/original/3X/4/0/40e53541de50650ecca8a77b0c9e93b3efba8c45.png) Or, if you want something more visual you can get very nice results using an Area Chart with 2 stacked metrics (average of memory.free and average of memory.used) You can see this in the screenshot below. ![visual_memory](https://us1.discourse-cdn.com/elastic/original/3X/7/1/71f7195468759f8865c01c75323b55b183177574.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 8, 2017, 6:47pm UTC](https://discuss.elastic.co/t/regarding-displaying-ram-in-pie-chart/102075/14 "2017-11-08T18:47:30Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.