# Use only unique fields for a visualization

**URL:** <https://discuss.elastic.co/t/use-only-unique-fields-for-a-visualization/207432>\
**Category:** Kibana\
**Tags:** elastic-stack-graph\
**Created:** [November 12, 2019, 2:44am UTC](https://discuss.elastic.co/t/use-only-unique-fields-for-a-visualization/207432 "2019-11-12T02:44:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lelwar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lelwar/32/45040_2.png) [@lelwar](https://discuss.elastic.co/u/lelwar)\
**Post date:** [November 12, 2019, 2:44am UTC](https://discuss.elastic.co/t/use-only-unique-fields-for-a-visualization/207432/1 "2019-11-12T02:44:26Z")

</div>

Hello,  
I am logging to elasticsearch requests made by one application. If there is a failure, a second, third, etc petition is made, nothing changes except 2 fields. I need to query to get visualization but only to use one of these documents. Is there a way to do this?

To explain a bit more lets say that I have 4 documents:

```
    {
number: 345
transactionId: 1
timestamp: 05:41
}

{
number: 345
transactionId: 1
timestamp: 05:42
}

{
number: 670
transactionId: 2
timestamp: 05:43
}

{
number: 720
transactionId: 3
timestamp: 05:44
}

{
number: 140
transactionId: 4
timestamp: 05:45
}

```

Now I want to do a sum visualization so that doc 1 is used, but not 2 (since is the same transaction). so that the sum of number is 345+670+720+140 instead of 345+345+670+720+140. Is this possible in Kibana? If not can I accomplish this with a script?

regards,

IC

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [November 18, 2019, 8:15pm UTC](https://discuss.elastic.co/t/use-only-unique-fields-for-a-visualization/207432/2 "2019-11-18T20:15:37Z")

</div>

I don't think this is possible in Kibana. You can ask in the Elasticsearch part of this forum to see if there's a way you can do it with a query.

---

<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 16, 2019, 8:15pm UTC](https://discuss.elastic.co/t/use-only-unique-fields-for-a-visualization/207432/3 "2019-12-16T20:15:40Z")

</div>

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