# Visual Builder Table Epoch

**URL:** <https://discuss.elastic.co/t/visual-builder-table-epoch/131920>\
**Category:** Kibana\
**Created:** [May 15, 2018, 11:32am UTC](https://discuss.elastic.co/t/visual-builder-table-epoch/131920 "2018-05-15T11:32:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![RdrgPorto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdrgporto/32/13278_2.png) [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Post date:** [May 15, 2018, 11:32am UTC](https://discuss.elastic.co/t/visual-builder-table-epoch/131920/1 "2018-05-15T11:32:04Z")

</div>

Hi everyone,

I am working on a **Visual Builder Table** when I group by a **date field** , it gets converted to **epoch** time format. An example:

 ![VisualBuilder](https://us1.discourse-cdn.com/elastic/original/3X/c/7/c7447847ee8f9962a15d4ec1b930a8b8c83fe9d4.PNG)

Thanks in advance 🖖,

Regards

---

<div class="post-metadata">

**Author:** ![simianhacker](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/simianhacker/32/3383_2.png) [@simianhacker](https://discuss.elastic.co/u/simianhacker)\
**Post date:** [May 15, 2018, 3:35pm UTC](https://discuss.elastic.co/t/visual-builder-table-epoch/131920/2 "2018-05-15T15:35:49Z")

</div>

This is because dates are actually stored as integers in Elastic. For the group by aggregation we are using a terms aggregation to calculate the buckets. Your best bet would be to use the table visualization (not the Visual Builder) and specify date histogram. If you want the latest value look at using the "top hits" aggregation with the table.

---

<div class="post-metadata">

**Author:** ![RdrgPorto](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rdrgporto/32/13278_2.png) [@RdrgPorto](https://discuss.elastic.co/u/RdrgPorto)\
**Post date:** [May 15, 2018, 4:01pm UTC](https://discuss.elastic.co/t/visual-builder-table-epoch/131920/3 "2018-05-15T16:01:39Z")

</div>

Thanks Chris 🙂

---

<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:** [June 12, 2018, 4:01pm UTC](https://discuss.elastic.co/t/visual-builder-table-epoch/131920/4 "2018-06-12T16:01:50Z")

</div>

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