# Unique counts wrong

**URL:** <https://discuss.elastic.co/t/unique-counts-wrong/142981>\
**Category:** Kibana\
**Created:** [August 3, 2018, 9:49pm UTC](https://discuss.elastic.co/t/unique-counts-wrong/142981 "2018-08-03T21:49:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Disha\_Nathani](https://avatars.discourse-cdn.com/v4/letter/d/f07891/32.png) [@Disha\_Nathani](https://discuss.elastic.co/u/Disha_Nathani)\
**Post date:** [August 3, 2018, 9:49pm UTC](https://discuss.elastic.co/t/unique-counts-wrong/142981/1 "2018-08-03T21:49:30Z")

</div>

I am trying to visualise, but want only uniques rows, latest ones. I am trying to use unique count, but it does only inside the bin, not accross the bins. Any help?

---

<div class="post-metadata">

**Author:** ![Joe\_Fleming](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/joe_fleming/32/3561_2.png) [@Joe\_Fleming](https://discuss.elastic.co/u/Joe_Fleming)\
**Post date:** [August 3, 2018, 10:31pm UTC](https://discuss.elastic.co/t/unique-counts-wrong/142981/2 "2018-08-03T22:31:57Z")

</div>

Yeah, I believe the unique count it provides is per bucket, so you need to modify how you define your buckets.

More information about your data and how you're trying to visualize it would help. It's hard to provide any advice if I don't know what you're working with and what you want to see.

---

<div class="post-metadata">

**Author:** ![Disha\_Nathani](https://avatars.discourse-cdn.com/v4/letter/d/f07891/32.png) [@Disha\_Nathani](https://discuss.elastic.co/u/Disha_Nathani)\
**Post date:** [August 6, 2018, 5:01pm UTC](https://discuss.elastic.co/t/unique-counts-wrong/142981/3 "2018-08-06T17:01:13Z")

</div>

I am trying to make a pie chart with two kind of status say true and false. I have ids which I am counting unique. So id 3 say was false and now changed to true. So I have two rows of id 3 in my data, with false and latest true. I want to count this entry only in true bucket and not in false. Any way that I can do this?

---

<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:** [September 3, 2018, 5:01pm UTC](https://discuss.elastic.co/t/unique-counts-wrong/142981/4 "2018-09-03T17:01:16Z")

</div>

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