# Visualise logs in data table using Terms Aggregation

**URL:** https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818
**Category:** Kibana
**Created:** [February 4, 2020, 1:41pm UTC](https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818 "2020-02-04T13:41:04Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![MPiorunn](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@MPiorunn](https://discuss.elastic.co/u/MPiorunn)
#### Post date: [February 4, 2020, 1:41pm UTC](https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818/1 "2020-02-04T13:41:04Z")

</div>

Hello

I am working on logs collecting using Elastic Stack and I wanted to present logs in a data table. They should be grouped by "Call ID", which I have achieved using Buckets with Terms aggregation.  
As you can see, each log consists of date, level , callId and message.

 ![Screenshot 2020-02-04 at 14.28.51](https://us1.discourse-cdn.com/elastic/original/3X/5/c/5c1e7578bf5e163abe52822e60ccc165695f85d3.png)  
Now the problem is, that the data table displays ONLY ONE log. I know that I can add more of them by 'concatenate' operation, but that will still place them in one line like this:  
message1, message2, message3,

instead of  
message1  
message2  
message2

I need to have each log in a separate row. Is it possible to do?

Note. I know that I can use Discover to filter my logs by Call Id, but this is not the case here. I need to have logs GROUPED by call Id.

---

<div class="post-metadata">

### Author: ![pchakour](https://avatars.discourse-cdn.com/v4/letter/p/e36b37/32.png) [@pchakour](https://discuss.elastic.co/u/pchakour)
#### Post date: [February 4, 2020, 3:19pm UTC](https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818/2 "2020-02-04T15:19:07Z")

</div>

Why did you use the split table ? Use the split row instead, it will be better in your case.

---

<div class="post-metadata">

### Author: ![MPiorunn](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@MPiorunn](https://discuss.elastic.co/u/MPiorunn)
#### Post date: [February 5, 2020, 7:57am UTC](https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818/3 "2020-02-05T07:57:09Z")

</div>

Thanks for a hint. I did a double-bucket-split.  
First one is the one that I presented.  
Second one is split row with @timestamp in ascending order. It has solved the problem, now I have small tabels with most recent logs for each Call ID.  
Thanks a lot, I'll mark it as a solution

---

<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: [March 4, 2020, 7:57am UTC](https://discuss.elastic.co/t/visualise-logs-in-data-table-using-terms-aggregation/217818/4 "2020-03-04T07:57:14Z")

</div>

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