Exclude duplicate data

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

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

Regards,
Aaron

2 Likes

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