# Using a "missing" field option in a group by statement in a Data Transform

**URL:** <https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069>\
**Category:** Elasticsearch\
**Created:** [February 12, 2020, 7:26pm UTC](https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069 "2020-02-12T19:26:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ebalmeida](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ebalmeida/32/47103_2.png) [@ebalmeida](https://discuss.elastic.co/u/ebalmeida)\
**Post date:** [February 12, 2020, 7:26pm UTC](https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069/1 "2020-02-12T19:26:41Z")

</div>

Hi guys,

I'm trying to create a data transform (using kibana's interface) in elasticsearch that includes missing docs for one of it's group by parameters as such:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/b/fb7f31f8e85fc8e189c7a445578ecb7e6f1ff779.png)  
However, once I hit apply changes, it obliterates the line and ignores the instruction.  
Is it a limitation? I've looked through the transform documentation and limitations but didn't find anything specifically referring to this.

---

<div class="post-metadata">

**Author:** ![Hendrik\_Muhs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hendrik_muhs/32/25802_2.png) [@Hendrik\_Muhs](https://discuss.elastic.co/u/Hendrik_Muhs)\
**Post date:** [February 13, 2020, 7:47am UTC](https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069/2 "2020-02-13T07:47:52Z")

</div>

Hi,

this is a known issue: [https://github.com/elastic/elasticsearch/issues/42941](https://github.com/elastic/elasticsearch/issues/42941)

However, a note in the docs would be a good thing, I agree.

Hendrik

---

<div class="post-metadata">

**Author:** ![ebalmeida](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ebalmeida/32/47103_2.png) [@ebalmeida](https://discuss.elastic.co/u/ebalmeida)\
**Post date:** [February 14, 2020, 3:07pm UTC](https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069/3 "2020-02-14T15:07:47Z")

</div>

I see!  
Thanks a lot. I've subscribed to the issue in Github

---

<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:** [March 13, 2020, 3:07pm UTC](https://discuss.elastic.co/t/using-a-missing-field-option-in-a-group-by-statement-in-a-data-transform/219069/4 "2020-03-13T15:07:51Z")

</div>

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