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