# Unique Count by Bucket
**URL:** https://discuss.elastic.co/t/unique-count-by-bucket/263978
**Category:** Kibana
**Created:** [February 11, 2021, 9:30am UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978 "2021-02-11T09:30:49Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Razvan\_Todea](https://discuss.elastic.co/u/Razvan_Todea)
#### Post date: [February 11, 2021, 9:30am UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/1 "2021-02-11T09:30:49Z")
How could we visualize an unique count grouped by bucket?
We understand that the counting will only check the uniqueness inside the bucket, but is it another way to achieve this?
Example: We want to visualize all the unique products a merchant has.
---
### Author:  [@dosant](https://discuss.elastic.co/u/dosant)
#### Post date: [February 11, 2021, 1:52pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/2 "2021-02-11T13:52:40Z")
Hi @Razvan_Todea, If I understood you correctly, then I think I've achieved what you've asked using TSVB:
Here I visualized uniq count of destinations per each carrier (using sample data set):
---
### Author:  [@Razvan\_Todea](https://discuss.elastic.co/u/Razvan_Todea)
#### Post date: [February 11, 2021, 2:52pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/3 "2021-02-11T14:52:12Z")
Hi @dosant , thank you for the reply.
I've checked your example, but it seems that is not working as expected. As you can see in the pictures. We have a total of 5 products -\> 3 products on merchant AWIN and 2 products on merchant Rakuten. But the ean: 1 appears in Rakuten and AWIN also (so is not unique). Instead of displaying that AWIN has 2 unique products, it should say that it only has 1 (the product with ean 3) and for Rakuten also 1 (the product with ean 2). The reasoning is that we want to know how many new products each merchant could get us.
 
---
### Author:  [@dosant](https://discuss.elastic.co/u/dosant)
#### Post date: [February 11, 2021, 3:29pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/4 "2021-02-11T15:29:13Z")
What results you expect in case you have 3 merchants and 2 of them have a product and another doesn't?
---
### Author:  [@Razvan\_Todea](https://discuss.elastic.co/u/Razvan_Todea)
#### Post date: [February 11, 2021, 3:43pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/5 "2021-02-11T15:43:59Z")
In that case the product is not unique, so it should not be take into consideration for the count.
Merchant 1: product\_ean: 1
Merchant 2: product\_ean: 1
Merchant 3: product\_ean: 2
The result should be:
Merchant 1: 0 unique products
Merchant 2: 0 unique products
Merchant 3: 1 unique products
---
### Author:  [@dosant](https://discuss.elastic.co/u/dosant)
#### Post date: [February 11, 2021, 4:13pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/6 "2021-02-11T16:13:54Z")
Unfortunately, I didn't find a way how to achieve this in Kibana ☹ Hope I didn't miss something obvious.
In case you'd find a way how to build such a complex aggregation with [elasticsearch aggregations](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations.html) then you could try building custom [Vega](https://www.elastic.co/guide/en/kibana/7.11/vega.html) visualization for your custom aggregation.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 11, 2021, 4:14pm UTC](https://discuss.elastic.co/t/unique-count-by-bucket/263978/7 "2021-03-11T16:14:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.