There is my sample dataset:
I can get a list of not unique text's in the table:
source
{
"aggs": {
"2": {
"terms": {
"field": "text.keyword",
"order": {
"_count": "desc"
},
"size": 5,
"min_doc_count": 2
}
}
},
"size": 0,
"fields": [
{
"field": "@timestamp",
"format": "date_time"
}
],
"script_fields": {},
"stored_fields": [
"*"
],
"_source": {
"excludes": []
},
"query": {
"bool": {
"must": [],
"filter": [
{
"match_all": {}
},
{
"range": {
"@timestamp": {
"gte": "2021-02-22T22:00:00.000Z",
"lte": "2021-02-23T21:59:59.999Z",
"format": "strict_date_optional_time"
}
}
}
],
"should": [],
"must_not": []
}
}
}
How to get the count of not unique text's in the metric visualisation?
In my case it should be like this: