How to hide weekends in time series graph?

Elastic Stack Kibana
1

Is it possible to hide weekend dates in a time series graph in Kibana?

2

There isn't a built in easy config to hide weekends. A possible solution could be date range aggregation with ranges set to not include weekends. Or possibly at index time to add a field stating whether it's a weekend or not and filter it out.

3

hey,

I would like to know how do you specify that? ( the format of From - To)
I would like also to hide the nights...
So to summarize I would like to work only with the weekdays from 8 to 12 for exemple.

Thanks

4

Pasted image409×776 36.4 KB

The available date formats can be found at https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html#date-math

5

I added a flag to elastic search documents which indicates is it a weekend or not. How to tell kibana to exclude those data points from graph?

6

In the search bar you can write something like myWeekendField:false

1 Like
7

Thanks will try it on monday!

8

I think that if you just add a flag, with the date histogram, you will still see the weekend dates on the graph , I will just hide the points if you have data for the Week end.
Concerning the Date Range and Date formats, I think it's a good idea even if I don't understand how can I specify that I want the data from Monday to Friday.
Let me know if you found anything.
Thank you