Date Histogram - Day of Week aggregation

[Paulo_Henrique_PH]

Hi @spinscale
Thanks for the reply.

Only if we index all the time zone available... not feasible in this scenario.
We've got it up running for other date formats (year, month and year etc)

I've tried this approach here:

Day of Week aggregation with TimeZone

I use ES 5.1.2 and I'm trying to compute day of week and time of day from a date field and consider timezone at the same time. my first script is def d = doc['my_field'].date; d.addHours(10); d.getDayOfWeek(); The error message is can't find addHours() method "caused_by": { "type": "illegal_argument_exception", "reason": "Unable to find dynamic method [addHours] with [1] arguments for class [org.joda.time.MutableDateTime]." }, "script_stack": [ "d.addHours(10); ", " ^---- HERE…

No luck unforcefully...