# Cannot access Flattened field in ElasticSearch Dashboard

**URL:** https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824
**Category:** Kibana
**Created:** [August 1, 2023, 3:29pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824 "2023-08-01T15:29:54Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Dana\_Pavaday](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dana_pavaday/32/123188_2.png) [@Dana\_Pavaday](https://discuss.elastic.co/u/Dana_Pavaday)
#### Post date: [August 1, 2023, 3:29pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824/1 "2023-08-01T15:29:54Z")

</div>

Hello,

I have created a transform where I have grouped by Client, BackupJob and BackupTool and I have put a terms aggregation in BackupStatus. The transform is displaying as expected in Discover. But when I try to create a table with this tranform, I have only Client, BackupJob and BackupTool fields in Dashboard and not BackupStatus.

I guess BackupStatus is not being seen in Dashboard since it has been used as an aggregation and hence is a Flattened field.

What should be done so that it is displayed in Dashboard to create a table?

---

<div class="post-metadata">

### Author: ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [August 2, 2023, 1:24pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824/2 "2023-08-02T13:24:26Z")

</div>

Hi @Dana_Pavaday. Flattened fields are not yet supported by Discover. We have an [existing feature request](https://github.com/elastic/kibana/issues/25820) with more info. There is also a [proposed workaround](https://github.com/elastic/kibana/issues/25820#issuecomment-958117227) using runtime fields.

---

<div class="post-metadata">

### Author: ![Dana\_Pavaday](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dana_pavaday/32/123188_2.png) [@Dana\_Pavaday](https://discuss.elastic.co/u/Dana_Pavaday)
#### Post date: [August 2, 2023, 2:04pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824/3 "2023-08-02T14:04:44Z")

</div>

Hello @nickpeihl,

I need the transform to generate classical fields. Only the BackupStatus field is being aggregated and it cannot be generated to create a table in the Dashboard.

Is there a way to make the aggregated BackupStatus field generated in the Dashboard?

---

<div class="post-metadata">

### Author: ![nickpeihl](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nickpeihl/32/112622_2.png) [@nickpeihl](https://discuss.elastic.co/u/nickpeihl)
#### Post date: [August 3, 2023, 2:14pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824/4 "2023-08-03T14:14:44Z")

</div>

Hi @Dana_Pavaday. Have you looked at the proposed workaround link I posted above? I'm not certain it will work, but it should be worth a try.

---

<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: [August 31, 2023, 2:14pm UTC](https://discuss.elastic.co/t/cannot-access-flattened-field-in-elasticsearch-dashboard/339824/5 "2023-08-31T14:14:45Z")

</div>

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