Hi guys, I'm facing a challenge while aggregating data by the "Week of Year" number. The use case is: The first day of the week is set as Sunday on my PC. create a data range: start='2018-06-24 Sunday' and end='2018-06-30 Saturday' Expected: I can only see one week aggregated Actual: I can see…

Hi, This did the trick: def date = ZonedDateTime.ofInstant(Instant.ofEpochMilli(doc[params.dt_field_name].value), ZoneId.of(params.timezone)); DayOfWeek dayOfWeek = DayOfWeek.valueOf(params.first_day_week); date = date.with(TemporalAdjusters.previousOrSame(dayOfWeek)).plusWeeks(1); return date.get…

Based on ISO 8601 it looks like weeks run from Monday through Sunday and not Sunday through Saturday. I'm not sure how you're setting first day of week on your PC, but if you do a week as Monday through Sunday instead, does this behave as expected?

Thanks for sharing your solution. That'd be definitely better to compute that at index time rather than at query time IMO.

Discuss the Elastic Stack

Week of the year aggregations using Painless

Elastic Stack Elasticsearch

Topic		Replies	Views
Week of the year aggregation Elasticsearch	1	572	October 25, 2018
How to set week start day in elastic Aggregation Elasticsearch	1	602	January 7, 2021
Accessing 'getWeekOfWeekyear()' when aggregating Elasticsearch	2	646	August 3, 2017
Week of the year / sunday of the week Kibana painless	2	418	April 27, 2021
Scripted fields ISO Week Elasticsearch	6	1834	July 5, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

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.

Week of the year aggregations using Painless

Related topics