# Kibana TSVB how to visualize unique records count

**URL:** https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474
**Category:** Kibana
**Created:** [November 21, 2022, 4:03pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474 "2022-11-21T16:03:32Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![azulgrana](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@azulgrana](https://discuss.elastic.co/u/azulgrana)
#### Post date: [November 21, 2022, 4:03pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/1 "2022-11-21T16:03:32Z")

</div>

Hi there!

I'm exploring TSVB and I couldn't find a way to report unique record count w/ the "counter" viz. Any guidance on that?

TIA

Azulgrana

---

<div class="post-metadata">

### Author: ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)
#### Post date: [November 21, 2022, 4:22pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/2 "2022-11-21T16:22:12Z")

</div>

Hi azulgrana,

Can you share the configuration you have so far? I think for a record count the easiest way would be using Lens and the count of the records field rather than TSVB:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/4/24f188a1e95679631cf2eceaef8abec97e9dfd5c.png)

Does that do what you need?

---

<div class="post-metadata">

### Author: ![azulgrana](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@azulgrana](https://discuss.elastic.co/u/azulgrana)
#### Post date: [November 21, 2022, 4:32pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/3 "2022-11-21T16:32:05Z")

</div>

@carly.richmond thanks for your quick response. I'm looking at using TSVB because I want to present a single counter with multiple metrics. See example below

![image](https://us1.discourse-cdn.com/elastic/original/3X/d/2/d292bb8d78ef48d693d36db048ea85cf2629a32e.png)

My TSVB now shows 1) total open records 2) New records in the last 31 days and I'm looking at adding total unique records in the same metric. I looked at the TSVB counter "aggregation" and I don't see any references to "unique count"

---

<div class="post-metadata">

### Author: ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)
#### Post date: [November 21, 2022, 5:24pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/4 "2022-11-21T17:24:15Z")

</div>

I suspect what you are looking for is the `Cardinality` aggregation for the field `X`: it will count how many unique values for the field `X` are in the selected time range.

In Lens the same function is named `Unique Count`.

---

<div class="post-metadata">

### Author: ![azulgrana](https://avatars.discourse-cdn.com/v4/letter/a/df788c/32.png) [@azulgrana](https://discuss.elastic.co/u/azulgrana)
#### Post date: [November 21, 2022, 5:28pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/5 "2022-11-21T17:28:48Z")

</div>

Thanks @Marco_Liberati I'll give that a try

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 19, 2022, 5:29pm UTC](https://discuss.elastic.co/t/kibana-tsvb-how-to-visualize-unique-records-count/319474/6 "2022-12-19T17:29:10Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.