# Exclude duplicate data
**URL:** https://discuss.elastic.co/t/exclude-duplicate-data/281226
**Category:** Kibana
**Created:** [August 12, 2021, 3:42pm UTC](https://discuss.elastic.co/t/exclude-duplicate-data/281226 "2021-08-12T15:42:44Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@dcarpio080](https://discuss.elastic.co/u/dcarpio080)
#### Post date: [August 12, 2021, 3:42pm UTC](https://discuss.elastic.co/t/exclude-duplicate-data/281226/1 "2021-08-12T15:42:44Z")
Hello,
Could you please help me to exclude the duplicate data from some charts that I'm creating for our executive team, basically I want to count the last update for each ticket, but It seems It is counting all the tickets depending on the status.
Example:
|INC-134161|||-------------------------------|||Open |Aug 11, 2021 @ 21:37:00.000|
|INC-134160|||Brayan Orias Moraga |||OnHold|Aug 11, 2021 @ 22:08:03.000|
|INC-134160|||-------------------------------|||Open |Aug 11, 2021 @ 20:31:03.000|
|INC-134160|||-------------------------------|||OnHold|Aug 11, 2021 @ 23:03:02.000|
I'm using the metric from the visualize option and Kibana v 7.9.1
Thank you for any help!
Regards
---
### Author:  [@Aaron\_Caldwell](https://discuss.elastic.co/u/Aaron_Caldwell)
#### Post date: [August 13, 2021, 10:02pm UTC](https://discuss.elastic.co/t/exclude-duplicate-data/281226/2 "2021-08-13T22:02:31Z")
Hello Daniel,
It sounds like you should be able to use the top hits agg here. See this discuss issue: [Top hits per type of each day](https://discuss.elastic.co/t/top-hits-per-type-of-each-day/206299)
Regards,
Aaron
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 10, 2021, 10:02pm UTC](https://discuss.elastic.co/t/exclude-duplicate-data/281226/3 "2021-09-10T22:02:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.