Advanced date query in Elasticsearch using Kibana

Kibana scripted fields might be of help here, but the current default scripting language based on Lucene expressions currently does not support date math. You could consider using static Groovy scripts instead, as described here, but it's really convoluted (note that using dynamic Groovy scripts is not secure).

As a result, at this time, I'd recommend simply indexing day-of-week as a separate field in Elasticsearch.