kibana – how to get the number of unique value which is has appeared more than twice days in elasticsearch?

for example,
{
user_name: someone
date: Nov 11
url: /app/home/someone
}

{
user_name: someone1
date: Nov 11
url: /app/home/someone1
}
{
user_name: someone2
date: Nov 11
url: /app/home/someone2
}
{
user_name: someone3
date: Nov 11
url: /app/home/someone3
}
{
user_name: someone
date: Nov 12
url: /app/home/someone
}
{
user_name: someone2
date: Nov 13
url: /app/home/someone2
}

=> Expected response would be,
[someone, someone2]
Because, someone and someone2 are unique username and they appeared in more than one day, however someone3 is not displayed beacuse it only appeared once

Read more here: Source link