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 ,
Regards
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 ,
Regards
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.
Thanks Chris
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
© 2020. All Rights Reserved - Elasticsearch
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.