# Display flattened fields on canvas

**URL:** https://discuss.elastic.co/t/display-flattened-fields-on-canvas/336233
**Category:** Kibana
**Created:** [June 16, 2023, 1:59pm UTC](https://discuss.elastic.co/t/display-flattened-fields-on-canvas/336233 "2023-06-16T13:59:34Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![witwit](https://avatars.discourse-cdn.com/v4/letter/w/74df32/32.png) [@witwit](https://discuss.elastic.co/u/witwit)
#### Post date: [June 16, 2023, 1:59pm UTC](https://discuss.elastic.co/t/display-flattened-fields-on-canvas/336233/1 "2023-06-16T13:59:34Z")

</div>

Hi everyone,

I have a set of logs that i've been processing. In processing, I managed to tag these logs types as file, download status etc. Afterwards, I used transform to group these logs based on files and aggregate download status terms counts as another index. Currently, I'm trying to display this data as a table with columns of file name, time stamp, and various download status terms counts. However, if I try to use canvas to create a table. I am unable to display the download\_status terms because it is a flattened field. Is there a way to bypass this?

I've tried using TSVB but on TSVB i'm unable to use the timestamp as one of the column for sorting. The sorting is quite important since I would prefer to show certain number of data based on past k hours etc.

If you guys know how to solve this, please help. Thank you.

---

<div class="post-metadata">

### Author: ![witwit](https://avatars.discourse-cdn.com/v4/letter/w/74df32/32.png) [@witwit](https://discuss.elastic.co/u/witwit)
#### Post date: [June 16, 2023, 2:09pm UTC](https://discuss.elastic.co/t/display-flattened-fields-on-canvas/336233/2 "2023-06-16T14:09:23Z")

</div>

Nvm I solved it by using the timestamp as row and the rest of the columns as metric. It's not perfect but it works

---

<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: [July 14, 2023, 2:09pm UTC](https://discuss.elastic.co/t/display-flattened-fields-on-canvas/336233/3 "2023-07-14T14:09:55Z")

</div>

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