I am new to Kibana and I need to make a visualization showing the number of unique logs (with respect to the message).
The logs retrieved by my search/query contain a field called "message", all of them having the following structure: "Process started for person: 1234", where 1234 represents the unique ID of the person. The process can be started several times for the same person, so I need to count the unique number of persons for which the process started.
I tried to use an unique count aggregation, but I am only allowed by Kibana to choose the field "message.keyword" , but I need to uniquely count the entire message (or just the ending).
I tried to create a scripted field in order to split the message field, but I keep getting compiler errors and I honestly don't know where to display them (I'm just told by Kibana "Discover: Compile error").
How would you solve this?
Thanks in advance and sorry if the answer is obvious, but, as I've said, I'm a beginner.