However, when I try to aggregate my data on several weeks, months or years, it is greyed and reset to 1. I cannot aggregate for instance on 3 months to have a quater.
Hi Pat. According to the documentation not possible for Elasticsearch to have a calendar_interval of multiple quantities. That is why Lens is disabling the field.
Instead of 3 months you may try using quarter to get an interval of one quarter.
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.