# Kibana Visualization to create Pie chart

**URL:** <https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316>\
**Category:** Kibana\
**Created:** [August 21, 2018, 7:30am UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316 "2018-08-21T07:30:38Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![thiraj89](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@thiraj89](https://discuss.elastic.co/u/thiraj89)\
**Post date:** [August 21, 2018, 7:30am UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/1 "2018-08-21T07:30:38Z")

</div>

we have log stack the values in message filed.  
"message": "Store - Hit from smarty. \tKey:paytm-hotels-booking\tTime: 2018-08-20 19:29:58"  
"message": "Store - Hit from smarty. \tKey:arzoo-domesticflights\tTime: 2018-08-20 19:29:58"  
"message": "Store - Hit from smarty. \tKey:zomato-coupons\tTime: 2018-08-20 19:29:58"

How to create pie chart in aggregate with Term the value of Key:XXXXXXX?. I want each key with count in pie chart. Any one guide me...

---

<div class="post-metadata">

**Author:** ![rijinmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rijinmp/32/24634_2.png) [@rijinmp](https://discuss.elastic.co/u/rijinmp)\
**Post date:** [August 21, 2018, 5:42pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/2 "2018-08-21T17:42:29Z")

</div>

Index this log in elasticsearch with a fileld name for keyvalue.

for example filed name is key .

in kibana select pie chart. create count of key .

then pie chart will show the percentage ( and count) of keys in total number of keys.

Example Paytm 50% arzoo 30% zomato 20%

---

<div class="post-metadata">

**Author:** ![thiraj89](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@thiraj89](https://discuss.elastic.co/u/thiraj89)\
**Post date:** [August 22, 2018, 2:27pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/3 "2018-08-22T14:27:20Z")

</div>

Thanks.. Without field name for key value index, any possibility to dynamically split the key value from message field and aggregate with Term.

---

<div class="post-metadata">

**Author:** ![rijinmp](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rijinmp/32/24634_2.png) [@rijinmp](https://discuss.elastic.co/u/rijinmp)\
**Post date:** [August 22, 2018, 7:56pm UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/4 "2018-08-22T19:56:11Z")

</div>

I think its possible by painless scripting in kibana . Only for visualization purpose . It will not affect the index fields and values.

With the help of painless you can count things from message.

I didnt tried any scripts for this purpose . Please check some kibana advanced scripting examples.

> **[Using Painless in Kibana scripted fields
	  	 | Elastic](https://www.elastic.co/blog/using-painless-kibana-scripted-fields)**
>
> Kibana provides powerful ways to search and visualize data stored in Elasticsearch. For the purpose of visualizations, Kibana looks for fields defined in Elasticsearch mappings and presents them as op...

---

<div class="post-metadata">

**Author:** ![thiraj89](https://avatars.discourse-cdn.com/v4/letter/t/3bc359/32.png) [@thiraj89](https://discuss.elastic.co/u/thiraj89)\
**Post date:** [August 23, 2018, 5:14am UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/5 "2018-08-23T05:14:26Z")

</div>

Thanks bro....

---

<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:** [September 20, 2018, 5:14am UTC](https://discuss.elastic.co/t/kibana-visualization-to-create-pie-chart/145316/6 "2018-09-20T05:14:29Z")

</div>

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