elasticsearchkibanakibana-7

Kibana Lens - Cannot cutomize timestamp on several months, weeks or years

I am creating a Lens Visualization on Kibana 7.17 When I try to customize my timestamp to aggregate data on several days, I can do it easily

enter image description here

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 quarter.

enter image description here

The same problem appears on weeks, and years.

Is there some trick to change timestamp to 2,3 or 4 months (or weeks or years)?

Solution

  • 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.

    Response copied from my post here