# How to show fields value on Data table Columns?

**URL:** <https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964>\
**Category:** Kibana\
**Created:** [November 19, 2020, 10:47am UTC](https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964 "2020-11-19T10:47:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rmrodrigues](https://avatars.discourse-cdn.com/v4/letter/r/d2c977/32.png) [@rmrodrigues](https://discuss.elastic.co/u/rmrodrigues)\
**Post date:** [November 19, 2020, 10:47am UTC](https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964/1 "2020-11-19T10:47:35Z")

</div>

Hi there,  
I'm a newbie here on Elastic.

Just to give you some context about my journey here, I'm trying elastic to build a business analytics system.  
I have an index where the document is something like this:

```auto
    {
  "_index": "my-app-event-index",
  "_type": "_doc",
  "_id": "eR9O3HUBaPzjFLFBydwe",
  "_version": 1,
  "_score": null,
  "_source": {
    "eventDate": "2020-11-18",
    "eventDateTime": "2020-11-18 08:45:04",
    "eventName": "Bulk Export",
    "appVersion": "6.5.5",
    "appPlatform": "Cluster",
    "customerName": "No Company Name",
    "platformVersion": "8.13.1",
    "properties": {
      "templateFormat": "XLSX",
      "outputFormat": "CSV",
      "IssuesCount": 16
    }
  },
  "fields": {
    "eventDate": [
      "2020-11-18T00:00:00.000Z"
    ]
  },
  "sort": [
    1605657600000
  ]
}

```

What I'd like to create a visualization where I can list a customer per Row and the total of events per type on columns. I'm trying to create a data table but I'm not being able to get the desired result.

Something like:  
Customer | Event A |Event B | Event C  
AAA | 12| 33| 12  
BBB | 13| 59| 42  
BBB | 2| 3| 1

What do you recommend? Suggestions to get this working?

Thank you so much.

Cheers,  
Rui Rodrigues.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [November 19, 2020, 4:21pm UTC](https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964/2 "2020-11-19T16:21:30Z")

</div>

This use case makes a lot of sense, but it doesn't 100% match the type of table we use for aggregation-based visualizations- because you are trying to show an aggregated value at the intersection of two keys, you have fewer options. Here are the ones I can think of:

1. Use a less-dense table, where you would have three columns: `Customer | Event type | Count`
2. Use a heatmap visualization instead of table. This visualization allows 2 bucketed axes, for both X and Y
3. Instead of using aggregations, you could pre-aggregate the data using the [ES transforms feature](https://www.elastic.co/guide/en/elasticsearch/reference/current/transforms.html). You could create an index which has the summary data you want, and then customize the table in Discover. Once you Save your search from discover, you can add it to a dashboard.

---

<div class="post-metadata">

**Author:** ![rmrodrigues](https://avatars.discourse-cdn.com/v4/letter/r/d2c977/32.png) [@rmrodrigues](https://discuss.elastic.co/u/rmrodrigues)\
**Post date:** [November 20, 2020, 11:11am UTC](https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964/3 "2020-11-20T11:11:05Z")

</div>

Hi @wylie,  
Thank you so much for your reply.  
I'm going to try all the suggestions you shared.

---

<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 18, 2020, 11:11am UTC](https://discuss.elastic.co/t/how-to-show-fields-value-on-data-table-columns/255964/4 "2020-12-18T11:11:21Z")

</div>

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