# How to generate Kibana pie chart for mentioned logs
**URL:** https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309
**Category:** Kibana
**Created:** [March 16, 2018, 1:55pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309 "2018-03-16T13:55:50Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@suripaleru](https://discuss.elastic.co/u/suripaleru)
#### Post date: [March 16, 2018, 1:55pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/1 "2018-03-16T13:55:50Z")
log row one: {"ORDER\_TYPE":"New","COUNT\_ROWS":"4"}
log row two: {"ORDER\_TYPE":"Change","COUNT\_ROWS":"10"}
log row two: {"ORDER\_TYPE":"Delete","COUNT\_ROWS":"50"}
I want to view above data in Pie like each section to be generated with count and legends as ORDER\_TYPE. could you suggest me an approach ?
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 16, 2018, 5:43pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/2 "2018-03-16T17:43:16Z")
Seems to me that you'd want to do the following:
For "metrics", choose Sum of COUNT\_ROWS.
For "buckets", choose Terms for ORDER\_TYPE.
Let me know if that helps!
---
### Author:  [@suripaleru](https://discuss.elastic.co/u/suripaleru)
#### Post date: [March 17, 2018, 10:06am UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/3 "2018-03-17T10:06:20Z")
Thank you but under metrics, I could not see fields under metrics which are visible under Split slices. Under metrics, I could only see "Levelofoder", "totalexecutionInmillisecons". Only these two are there under metric section.
---
### Author:  [@suripaleru](https://discuss.elastic.co/u/suripaleru)
#### Post date: [March 19, 2018, 9:11pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/4 "2018-03-19T21:11:17Z")
Hi, Any updates on this ?
---
### Author:  [@lukas](https://discuss.elastic.co/u/lukas)
#### Post date: [March 20, 2018, 5:27pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/5 "2018-03-20T17:27:30Z")
Could you copy/paste your index pattern mapping here?
---
### Author:  [@suripaleru](https://discuss.elastic.co/u/suripaleru)
#### Post date: [March 20, 2018, 5:58pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/6 "2018-03-20T17:58:31Z")
Issue fixed from this thread
> [@All fields are not listed under metric drop down](https://discuss.elastic.co/t/all-fields-are-not-listed-under-metric-drop-down/124789/3):
>
> Thank you for quick reply. Based on your comment, I understood in this way. If my log data is like this as mentioned below log row one: {"ORDER\_TYPE":"New","COUNT\_ROWS":4} log row two: {"ORDER\_TYPE":"Change","COUNT\_ROWS":10} log row two: {"ORDER\_TYPE":"Delete","COUNT\_ROWS":50} in this case, COUNT\_ROWS will appear under Metrics but ORDER\_TYPE will not. Is this correct ?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 17, 2018, 5:59pm UTC](https://discuss.elastic.co/t/how-to-generate-kibana-pie-chart-for-mentioned-logs/124309/7 "2018-04-17T17:59:02Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.