Kibana Visualization to create Pie chart

Elastic Stack Kibana
1

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...

2

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%

3

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

4

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.

5

Thanks bro....

1 Like
6

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