Hello, I need to do an unique count of items that are duplicates, let me explain.
We use customer.id , it is unique for every customer. What we would like to visualize is only the customer.id's that are logged more than once in our index.
Example
Tom - Appears once
Jhon - Appears twice
Simon - Appears tree times
We only want to count Jhon and Simon, so the count should be 2 instead of 3.
Is this doable in Kibana or not ?
On the second index you can now create a metric visualization, filter by count > 1 and show the "Unique count" of customer.id - this will give you the value you need.
If your source index has a timefield, transforms can also be set up to continuously run in the background pre-aggregating incoming data.
Thank you, just what I needed.
I feel I can't use time options tho?
Changing date frame and adding data historygram does nothing.
I have added @timestamp as an aggregate as well.
Hi Everyone. Can I use "Transform" from elasticsearch for Basic License?
Actually I'm working on the basic license of Kibana and I'm unable to find that "Transform" panel in elasticsearch. I'm currently using Kibana 6.8.7
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.