Visual Builder Table Epoch

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:

Thanks in advance :vulcan_salute:,


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.

1 Like

Thanks Chris :slight_smile:

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