# Merge entries of data view

**URL:** <https://discuss.elastic.co/t/merge-entries-of-data-view/364841>\
**Category:** Kibana\
**Tags:** data-views, visualisation\
**Created:** [August 13, 2024, 3:32pm UTC](https://discuss.elastic.co/t/merge-entries-of-data-view/364841 "2024-08-13T15:32:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sz118](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@sz118](https://discuss.elastic.co/u/sz118)\
**Post date:** [August 13, 2024, 3:32pm UTC](https://discuss.elastic.co/t/merge-entries-of-data-view/364841/1 "2024-08-13T15:32:07Z")

</div>

Hello everyone,

I’m new to Kibana and I’d like to find a way to merge the entries of my data view.

The data view contains field2 with the values “Verification passed…” or “Verification failed…” and a following string. I’d like to merge all strings so that in a pie chart visualization just entries for “Verification passed…” or “Verification failed…” exist.

In the attached screenshot there would be 5 entries in the pie chart, because all strings in field2 differ. But there should be 2 entries (4 times “passed” and 1 time “failed”).

Does anyone have an idea? My guess is that it could be solved with the scripting function of Kibana?

Screenshot attached of the data view.

Thanks and kind regards,

Soeren

 ![dataview](https://us1.discourse-cdn.com/elastic/original/3X/e/d/ed33777ca9249f07e3ebbad5dd4d64fd4cdb60e2.png)

---

<div class="post-metadata">

**Author:** ![sz118](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@sz118](https://discuss.elastic.co/u/sz118)\
**Post date:** [August 13, 2024, 3:36pm UTC](https://discuss.elastic.co/t/merge-entries-of-data-view/364841/2 "2024-08-13T15:36:37Z")

</div>

Added #data-views, #visualisation

---

<div class="post-metadata">

**Author:** ![sz118](https://avatars.discourse-cdn.com/v4/letter/s/9e8a1a/32.png) [@sz118](https://discuss.elastic.co/u/sz118)\
**Post date:** [August 14, 2024, 12:05pm UTC](https://discuss.elastic.co/t/merge-entries-of-data-view/364841/3 "2024-08-14T12:05:50Z")

</div>

I solved it. For the visualization in Buckets I used FIlters as aggregation type. Then I used 2 filters, one for passed and one for failed.