# Errors grouping in Data Table, how to add more columns?

**URL:** https://discuss.elastic.co/t/errors-grouping-in-data-table-how-to-add-more-columns/146685
**Category:** Kibana
**Created:** [August 30, 2018, 11:27am UTC](https://discuss.elastic.co/t/errors-grouping-in-data-table-how-to-add-more-columns/146685 "2018-08-30T11:27:29Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![caub](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/caub/32/33783_2.png) [@caub](https://discuss.elastic.co/u/caub)
#### Post date: [August 30, 2018, 11:27am UTC](https://discuss.elastic.co/t/errors-grouping-in-data-table-how-to-add-more-columns/146685/1 "2018-08-30T11:27:30Z")

</div>

I made this Data Table for visualizing errors, by most frequent occurrences

I used a Terms aggregation on error.stack field (I'd have preferred error.message, but it's not listed)

 ![2018-08-30-132119_1436x601_scrot](https://us1.discourse-cdn.com/elastic/original/3X/6/f/6f23ce219dbc2ae382abb2b989e12ab6b44f80c9.png)

I'd like to add other 'descriptive' columns on each row, for example the error.message field, the last timestamp, and a way to link to the full log data for this event

similarly to google error reporting below:

 ![2018-08-30-132315_1424x486_scrot](https://us1.discourse-cdn.com/elastic/original/3X/c/2/c296497d5c9dc45fefbb8ea1f56e3734f157ed68.png)

slightly related: [Grouping values?](https://discuss.elastic.co/t/grouping-values/117001/13)

---

<div class="post-metadata">

### Author: ![Larry\_Gregory](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/larry_gregory/32/34969_2.png) [@Larry\_Gregory](https://discuss.elastic.co/u/Larry_Gregory)
#### Post date: [August 30, 2018, 1:11pm UTC](https://discuss.elastic.co/t/errors-grouping-in-data-table-how-to-add-more-columns/146685/2 "2018-08-30T13:11:54Z")

</div>

@caub,

For `text` and `keyword` fields, you can take advantage of the "Top Hit" metric to add additional columns to your data table.

To add a timestamp, you can select an aggregation metric (such as min or max) to grab a specific timestamp:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/4/b40277127f6046cbafae6f592157f6e2a3512c39.png)

---

<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: [September 27, 2018, 1:11pm UTC](https://discuss.elastic.co/t/errors-grouping-in-data-table-how-to-add-more-columns/146685/3 "2018-09-27T13:11:57Z")

</div>

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