How to get the counts of log messages based on the

问题:

I have some sample data on the Elasticsearch, which looks like the following:

I am using the data table in the Visualize section to get the counts for each error type, for example: it should output

Error: Update failed for online booking with id, count is 5.

Not the count 1 for different id of the same error type.

What I have done is to build a query to output the counts for each error type, which looks like this:

However, when I save the query as the saved search, then visualize it as data table, it still have the same issue as above.

I was thinking to only save the output of that query as saved search, one issue is that the output is too verbose, has a lot of information I don't really need.

Any suggestions please !