How to draw pie-chart visualization in kibana with the data of sub-string values of a similar records as explained below?

Question

kibana has filtered out the following data records as shown below

message:"I wish to go to"

Filter Results:

message:I wish to go to India
message:I wish to go to Australia
message:I wish to go to China
message:I wish to go to Japan
message:I wish to go to India
message:I wish to go to Australia
message:I wish to go to India
message:I wish to go to Australia
message:I wish to go to India
message:I wish to go to India
message:I wish to go to Australia

I need to draw a visualization pie-chart with the count of sub-string data in * here

( I wish to go to *)

I need the visualization like this:

How to do this?

I need the visualization of counts of the values ( marked as * above). Also, I wanted the chart dynamically change as the new data arrives with different values. — Anish, Feb 28 '18 at 16:33

score 0 · Answer 1 · answered Mar 01 '18 at 07:01

0

Create a scripted field, (say) destination, in kibana with script like "params['_source']['message'].substring(13)"

In the pie-chart visualization, use "Count" as Metric and split the slices on "destination".

answered Mar 01 '18 at 07:01

sammy

524
4
11

How to draw pie-chart visualization in kibana with the data of sub-string values of a similar records as explained below?

1 Answers1