How to groupby unique values from elasticsearch with grafana --HELP!

Info:

  • Grafana 7.5.7
  • Elastic 7.11
  • Linux OS

I would like to know how can I get unique values from elasticsearch with Grafana’s query editor.

I have the next picture:

It shows SSH Detected several times and I wish it just once.

I don’t know how to do this, so if anyone knows how can I do, I’ll be grateful.

Thanks!

Besides, I have this another issue: Regex Query in Grafana HELP!