# Create a table showing two "sibling" elements
**URL:** https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112
**Category:** Kibana
**Created:** [July 7, 2021, 9:04pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112 "2021-07-07T21:04:41Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@rgahan5c](https://discuss.elastic.co/u/rgahan5c)
#### Post date: [July 7, 2021, 9:04pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/1 "2021-07-07T21:04:41Z")
I have data that is in the form:
```auto
{
user_email: "test@example.com",
number_of_emails_sent: 100,
...
}
```
I would like to display it in a table like:
| User Email | Number of Emails Sent |
| --- | --- |
| test@example.com | 100 |
I have tried to do it via Data Table visualization, as well as in TSVB, to no avail. Is this possible?
As a bonus question, I will get one document for each user every day. Is there a way to make the visualization only utilize the most recent document associated with the user? Or would you handle that via time filters?
---
### Author:  [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)
#### Post date: [July 7, 2021, 10:01pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/2 "2021-07-07T22:01:29Z")
Hi,
You should take a look at lens and its definitely possible [Kibana Lens | Elastic](https://www.elastic.co/kibana/kibana-lens)
I would say handling the most recent document via timepicker is the easiest way to go. You can also save the search or the dashboard with timepicker for the last time period in which case every time you open it - you will open it for your needed time period.
Thanks
Bhavya
---
### Author:  [@rgahan5c](https://discuss.elastic.co/u/rgahan5c)
#### Post date: [July 8, 2021, 1:32pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/3 "2021-07-08T13:32:03Z")
When I use Lens, I can make a table laid out like:
| Top values of user\_email.keyword | Top values of number\_of\_emails\_sent.keyword | Count of records |
| --- | --- | --- |
When what I'm looking for is:
| User Email | Number of Emails Sent |
| --- | --- |
| test@example.com | 100 |
| And so on each user |
Is that possible, either in Lens or another tool?
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [July 8, 2021, 1:46pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/4 "2021-07-08T13:46:01Z")
Try using the "Last value" for your number of emails sent instead of a count of records as the metric.
---
### Author:  [@rgahan5c](https://discuss.elastic.co/u/rgahan5c)
#### Post date: [July 8, 2021, 1:48pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/5 "2021-07-08T13:48:35Z")
Where might I find that option in Lens? I don't see it when I click on the number of emails sent column in the section on the right of the screen
UPDATE:
I changed the grouping to both overall top and then top value for each, and neither of them gave what I was looking for. Additionally, when I removed the "count of records" column, the table doesn't display any data.
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [July 8, 2021, 2:34pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/6 "2021-07-08T14:34:15Z")
try moving "number of emails sent" to "metric" instead of column
---
### Author:  [@rgahan5c](https://discuss.elastic.co/u/rgahan5c)
#### Post date: [July 8, 2021, 3:06pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/7 "2021-07-08T15:06:07Z")
I am running Kibana 7.7.1, is this feature available for that version? I don't see that option when looking at the Lens page.
---
### Author:  [@ghudgins](https://discuss.elastic.co/u/ghudgins)
#### Post date: [July 8, 2021, 3:33pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/8 "2021-07-08T15:33:34Z")
ah, yeah. it's not available in Lens in 7.7 and unfortunately "Top Hits" isn't available in non-Lens data tables either in your version.
you could do a non-Lens vertical / horizontal bar chart set up to "Top Hits" (same aggregation Lens' "Last Value" uses)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 5, 2021, 3:33pm UTC](https://discuss.elastic.co/t/create-a-table-showing-two-sibling-elements/278112/9 "2021-08-05T15:33:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.