Create weekday barchart from timestamp

Elastic Stack Kibana
1

Hi,

I am trying to create a bar chart where I have both the average documents count per day of the week (eg Monday to Sunday) over the entire period and the documents count over the current week.
So far I have only managed to query the total documents count per day of the week (see query below) but I don't know how to create the visualization.

POST /myindex/_search?size=0
{
  "query":{
    "match_all": {}
  },
    "aggs": {
        "dayOfWeek": {
            "terms": {
                "script": {
                    "lang": "painless",
                    "source": "doc['date'].value.dayOfWeek"
                }
            }
        }
    }
}

The result I would like to obtain is as follows:
image

Thanks for you help

2

Hey @OlivierV, you'll want to start by creating a Kibana scripted field for the dayOfWeek, and then you can create a Vertical Bar Chart with the following configuration:

26%20PM
Screen Shot 2018-07-09 at 12.59.26 PM.png730×1480 48.1 KB
36%20PM
Screen Shot 2018-07-09 at 12.59.36 PM.png730×1172 48.7 KB

Make sure that you include the "JSON Input" sections, to get gaps to be reflected right in the averages.

3

Thanks it worked!

I just have one more issue which is UI related: how can I map the day_of_week values (eg 1 to 7) to string values Monday to Sunday on the chart?

4

Hey @OlivierV, I'd recommend changing your scripted field to return the string of Monday to Sunday. There isn't away via Kibana's Visualize to perform this translation at the moment.

5

Yeah that's what I've tried but then it messes the way days are ordered like it orders them alphabetically