# Filtering the redundant dataView column value

**URL:** <https://discuss.elastic.co/t/filtering-the-redundant-dataview-column-value/347087>\
**Category:** Kibana\
**Tags:** elastic-stack-alerting\
**Created:** [November 14, 2023, 7:44am UTC](https://discuss.elastic.co/t/filtering-the-redundant-dataview-column-value/347087 "2023-11-14T07:44:33Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![talk2raja](https://avatars.discourse-cdn.com/v4/letter/t/7ba0ec/32.png) [@talk2raja](https://discuss.elastic.co/u/talk2raja)\
**Post date:** [November 14, 2023, 7:44am UTC](https://discuss.elastic.co/t/filtering-the-redundant-dataview-column-value/347087/1 "2023-11-14T07:44:33Z")

</div>

I am using an Elasticsearch query, trying to send an alert based on **FPS\_MIN** ,

My query & conditions,  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/8/088525ba39ed41a0b31330ab270c1a8ca5201828.png)

My problem is, that I got 39 hits, I am looping the **hits** result in alert action message section,  
**server.name** value will be **SERVER\_1** to **SERVER\_n**

```auto
{{#context.hits}}
  - {{_source.server.name}} : {{_source.json.FPS_MIN}}
{{/context.hits}}

```

In the 39 iterations, I have the same `server.name`, I don't want to show the same `server.name` multiple times, Instead of that I want to show once, for each `server.name`.

Currently, I have only one **SERVER\_1** , In the future we might add more,  
I need to make a group by my **server.name** like this,

```auto
FPS' is Dropping into 0:

- SERVER_1 : 0

```

---

<div class="post-metadata">

**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\
**Post date:** [November 22, 2023, 9:38pm UTC](https://discuss.elastic.co/t/filtering-the-redundant-dataview-column-value/347087/2 "2023-11-22T21:38:18Z")

</div>

@ying.mao / @pmuellr could we please get some help? Thanks!

---

<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 20, 2023, 9:38pm UTC](https://discuss.elastic.co/t/filtering-the-redundant-dataview-column-value/347087/3 "2023-12-20T21:38:33Z")

</div>

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