I created a scripted field to extract the hour of the week from @timestamp
and its working fine.
But when i try to extract the day of week using this query in dev tools
It's working fine as well but this scripted field gives me shard failed error when i use discover for filebeat-7.8*.
Can anyone share how to get the day of week using scripted field? i will use thi scripted in visualizations