Visual Builder Table Epoch


(Rodrigo Porto) #1

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:,

Regards


(Chris Cowan) #2

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.


(Rodrigo Porto) #3

Thanks Chris :slight_smile:


(system) #4

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