1 year ago
#382246
mort_m
How to create an aggregation over unique count in Kibana?
I have an index in ElasticSeach with data for last 6h like:
[
{
"user": "001",
"id": "001001",
"timeOK": "true",
"timestamp": "1649246222885"
},
{
"user": "002",
"id": "002002",
"timeOK": "true",
"timestamp": "1649246222887"
},
{
"user": "003",
"id": "003003",
"timeOK": "true",
"timestamp": "1649246222888"
},
{
"user": "001",
"id": "001001",
"timeOK": "false",
"timestamp": "1649246222899"
},
{
"user": "001",
"id": "001001",
"timeOK": "false",
"timestamp": "1649246224899"
},
{
"user": "004",
"id": "002002",
"timeOK": "true",
"timestamp": "1649246223299"
},
]
Every time there is an interaction of the user I am logging a new record. I am trying to find a way how to create a visualization which would present an average of unique counts per id in last 6h (or any time interval). So for example above in last 6h there is:
"id": "001001" unique count 3 "id": "002002" unique count 2 "id": "003003" unique count 1
So the average would be 2. Is it possible to create a visualization for this? Or a way how I can get and present that data?
elasticsearch
kibana
visualization
vega
0 Answers
Your Answer