I am not able to make graph on strings in kibana

I have a column name "Miss message" . I just want to make a graph to show how many times miss messages are repeated but it is not even showing in the columns. I am trying to create in data table but it is not even showing in any other graphs.

but miss messages is the random text every time not a fixed pattern.
you want to show the count on miss messages , is it the case?

There are a total of 10000 rows but I have just used 10 miss messages in all of them as random.

can you post the _mapping for this index?

{
"demo5" : {
"mappings" : {
"_meta" : {
"created_by" : "ml-file-data-visualizer"
},
"properties" : {
"@timestamp" : {
"type" : "date"
},
"Customer Retention" : {
"type" : "keyword"
},
"Goal Completion rate" : {
"type" : "long"
},
"Goal Completion time" : {
"type" : "long"
},
"Miss Messages" : {
"type" : "keyword"
},
"No bot messages" : {
"type" : "long"
},
"No in-messages" : {
"type" : "long"
},
"No of miss messages" : {
"type" : "long"
},
"Timestamp" : {
"type" : "date",
"format" : "yyyy-MM-dd HH:mm:ss"
},
"Total Conversation" : {
"type" : "long"
},
"User Id" : {
"type" : "long"
},
"User Satisfaction" : {
"type" : "long"
},
"Users" : {
"type" : "keyword"
}
}
}
}
}

not able to understand tough you can achieve it by using filter aggregation with all the 10 text of the miss message

The problem is that only it is not showing in field options.

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