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
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.
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
- Elasticsearch intermittently killed
- Elasticsearch: Job for elasticsearch.service failed
- problem with adding new node to elasticsearch cluster
- AWS SSO/AWS Opensearch SAML integration
- Logstash field is never shown after aggregation
- Elastic Search total index size
- Elastic Search Give an error No alive nodes found in your cluster
- The remote server returned an error: (413) Request Entity Too Large. Elasticsearch and JSON
- unassigned_shards how to solve it
- Elasticsearch: Match range in list of start and end dates
- How to test threat intel filebeat module rule in ELK
- Using Shingles and Stop words with Elasticsearch and Lucene 4.4
- how to do custom grouping of aggregations?
- How can I handle large keyword fields in OpenSearch?
- ElasticSearch-dsl intervals query
- How to configure Elastic.Serilog.Sinks librari with appsettings.json?
- Elasticsearch Curl Command with Sudo Permission Works, But Without Sudo or Using Simple Curl Command Returns Empty Response
- How to check if a homebrew service is switched on or not
- How can I know which nodes in a cluster are actual master nodes?
- Curl 77 Error setting certificate file: http_ca.crt
- Elasticsearch Get only those date histograms whose bucket size is greater than given number
- How to put a size on a date_histogram aggregation
- How to copy some ElasticSearch data to a new index
- IDE for elasticsearch
- Elasticsearch showing received plaintext http traffic on an https channel in console
- How to make facet search by multiple nested fields in Elasticsearch Java API Client?
- Elasticsearch English stemming not working correctly
- How to take the current week's data (from the beginning of the week) from elasticsearch query irrespective of present week?
- Why does Elasticsearch use 9 GB of memory, with default settings?
- Fetch data from a middle of a big stack using searchAfter(jump to a specific page,)