Need Weekdays from timestamp

Hi! I want to count a large dataset group by weekdays. With scripted fields is it too slow.
How can i add new index field weekday given by timestamp?
Thanks a lot!

I would suggest adding that field before you send the data to Elasticsearch. You could accomplish this using Logstash I think. For details on how to do it, I would ask in the Logstash forum.

1 Like

Thanks, this is my second solution - but it should be possible for existing data (20M datasets). It should possible to add calculated fields, so you can access them for the future rapidly.

You can definitely add a scripted field that would accomplish this, it's just going to be slow for large data sets (as you point out in your original post).

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.