# Lens - Summary Data Table

**URL:** <https://discuss.elastic.co/t/lens-summary-data-table/359413>\
**Category:** Kibana\
**Tags:** visualisation\
**Created:** [May 13, 2024, 8:50pm UTC](https://discuss.elastic.co/t/lens-summary-data-table/359413 "2024-05-13T20:50:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [May 13, 2024, 8:50pm UTC](https://discuss.elastic.co/t/lens-summary-data-table/359413/1 "2024-05-13T20:50:11Z")

</div>

Hello is there a way to recreate this using Lens,

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

The goal is to show a user with all instances of ip addresses and host name with last timestamp for each.

---

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [May 14, 2024, 10:07pm UTC](https://discuss.elastic.co/t/lens-summary-data-table/359413/2 "2024-05-14T22:07:39Z")

</div>

I was able to do it as two separate aggregation data tables:

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/5/f5c18bb646d5dec67abbc32dfe697770a707d24d.png)

Issue still remains as this dependent on filtering and would be nice to have to a way to put this all into one report so it can be exported.

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [May 15, 2024, 8:33am UTC](https://discuss.elastic.co/t/lens-summary-data-table/359413/3 "2024-05-15T08:33:05Z")

</div>

Hi @erikg

I see. I guess your reporting would be something like CSV.

The only alternative I can propose here to unify, is to define in the left table a metric column as `overall_sum(unique_count( logon_time_field))` who will be repeated for each row:

 ![Screenshot 2024-05-15 at 10.31.15](https://us1.discourse-cdn.com/elastic/original/3X/f/1/f1cff0effb8976d5169653299f6261537a9ed4d1.png)

With that the table should be single and it would be possible to have a CSV.