![\"\"](\"https:\/\/trifork.nl\/articles\/wp-content\/uploads\/sites\/3\/2017\/08\/blog-kibana-day-of-week-first-visualization.png\")
<\/p>\nI keep track of my daily commutes to and from the office. One thing I want to know is how the different days of the week are affecting my travel duration. But when indexing all my commutes into Elasticsearch, I can not (out-of-the-box) create a histogram on the day of the week. My first visualization will look like this:<\/p>\n
<\/p>\n
<\/p>\n
Luckily, using the Painless scripting language, I can add a scripted field to my ‘index’. I am not really adding it to my Elasticsearch index. I am adding it to Kibana’s view of the index. Under “Management”, “Index Patterns” and “scripted fields”, I can add a Painless script that will generate the content of the field.<\/p>\n
I use I can now create a new visualization using a histogram instead of a date histogram:<\/p>\n But there is still something I can improve. The days of the week are now called 1 through 5 (not 7, because I generally do not commute in weekends).<\/p>\n If I alter the scripted field to I keep track of my daily commutes to and from the office. One thing I want to know is how the different days of the week are affecting my travel duration. But when indexing all my commutes into Elasticsearch, I can not (out-of-the-box) create a histogram on the day of the week. My first visualization […]<\/p>\n","protected":false},"author":89,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","footnotes":""},"categories":[113,15,65],"tags":[61,92,433],"class_list":["post-15081","post","type-post","status-publish","format-standard","hentry","category-axon","category-enterprise-search","category-big_data_search","tag-elasticsearch","tag-kibana","tag-painless"],"acf":[],"yoast_head":"\ndoc['timestamp'].date.dayOfWeek<\/code> to get a numeral representation of the day of the week: 1 for Monday, 7 for Sunday:<\/p>\n![\"\"](\"https:\/\/trifork.nl\/articles\/wp-content\/uploads\/sites\/3\/2017\/08\/blog-kibana-day-of-week-scripted-field.png\")
<\/p>\n![\"\"](\"https:\/\/trifork.nl\/articles\/wp-content\/uploads\/sites\/3\/2017\/08\/blog-kibana-day-of-week-discovery-2.png\")
<\/p>\n![\"\"](\"https:\/\/trifork.nl\/articles\/wp-content\/uploads\/sites\/3\/2017\/08\/blog-kibana-day-of-week-better-visualization.png\")
<\/p>\ndoc['timestamp'].date.dayOfWeek + \" (\" + [\"\", \"Mon\", \"Tue\", \"Wed\", \"Thu\", \"Fri\", \"Sat\", \"Sun\"][doc['timestamp'].date.dayOfWeek] + \")\"<\/code>, I will be able to create a much more readable x-asis:<\/p>\n![\"\"](\"https:\/\/trifork.nl\/articles\/wp-content\/uploads\/sites\/3\/2017\/08\/blog-kibana-day-of-week-readable-x-axis.png\")
<\/p>\n","protected":false},"excerpt":{"rendered":"