# Group by data in data table

**URL:** <https://discuss.elastic.co/t/group-by-data-in-data-table/56639>\
**Category:** Kibana\
**Created:** [July 28, 2016, 2:40pm UTC](https://discuss.elastic.co/t/group-by-data-in-data-table/56639 "2016-07-28T14:40:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jpry](https://avatars.discourse-cdn.com/v4/letter/j/ecae2f/32.png) [@jpry](https://discuss.elastic.co/u/jpry)\
**Post date:** [July 28, 2016, 2:40pm UTC](https://discuss.elastic.co/t/group-by-data-in-data-table/56639/1 "2016-07-28T14:40:55Z")

</div>

Hi there,

I would like to group my data using data table visualization so that, if I take the example attached, for each same hostname I could have all the categories gathered in a raw and the corresponding count values summed up?.

e.g:  
[pipe.skype.com](http://pipe.skype.com) =\>Chat.., Internet Telephony  
[isee.europe.hp.com](http://isee.europe.hp.com) =\> Technology/Internet, URLs\_...,URLs\_UNIX\_...,URLs\_Windows\_..  
...  
etc.

Another question, is there a way to rename the columns?

![](https://us1.discourse-cdn.com/elastic/original/2X/2/20e5d3eb04ba44c13254a5b4652d6fa19a0cec06.png)

---

<div class="post-metadata">

**Author:** ![jbudz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jbudz/32/45922_2.png) [@jbudz](https://discuss.elastic.co/u/jbudz)\
**Post date:** [August 1, 2016, 8:16pm UTC](https://discuss.elastic.co/t/group-by-data-in-data-table/56639/2 "2016-08-01T20:16:58Z")

</div>

There isn't currently a way to do that that I can think of. The best I can think of right now is adding another table (or chart) with only a terms aggregation on host.raw if you need the combined counts.

Metric/column labels are available in 4.5+, [https://github.com/elastic/kibana/pull/6123](https://github.com/elastic/kibana/pull/6123)

---

<div class="post-metadata">

**Author:** ![JuanCarniglia](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/juancarniglia/32/11154_2.png) [@JuanCarniglia](https://discuss.elastic.co/u/JuanCarniglia)\
**Post date:** [August 2, 2016, 2:48am UTC](https://discuss.elastic.co/t/group-by-data-in-data-table/56639/3 "2016-08-02T02:48:26Z")

</div>

If you are still struggling with this, I recommend that you build a custom visualization (Plugin).

It's not that hard, I can give some pointers, or you can check out examples at my github ([https://github.com/JuanCarniglia](https://github.com/JuanCarniglia)).

If you need/want I can develop this visualization for you.

Let me know, I hope this helps.

---

<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 6, 2017, 1:42pm UTC](https://discuss.elastic.co/t/group-by-data-in-data-table/56639/4 "2017-07-06T13:42:41Z")

</div>