[Lens] Time series only for weekdays

[RitikaG]

Can we have a histogram plotted only for the weekdays i.e. exclude all Saturdays and Sundays?
The data I need to plot is applicable only for weekdays. So it shows drop for al weekends which does not signify the representation of data properly

[rashidkpc]

This is an interesting idea, though would make for a sort of odd UI as time would no longer be linear.

[RitikaG]

At present, how is the x axis rendered? We can easily find out the day corresponding to a given number(that represents the date). All we need to do is exclude if its Saturday or Sunday. How can we go about that?

[bgagnon]

The initial proposal from #2910 would be a good way to satisfy the continuous axis criteria. The ticket was since merged into #1983, but I personally think highlighted ranges like weekends are different than markers.

[timroes]

@elastic/kibana-visualizations In my opinion that would be a perfect option for the new editor, that as long as we visualize something in a "daily"/"monthly" manner over time, we allow users to filter out specific days/month via a configuration, that will vanish completely from the charts (and not leave a gap).

[markov00]

@timroes yes for sure, but keep in mind that an histogram has a continuous independent variable (the x axis as a linear scale) and each bar goes from the value A to the value B.

Removing intervals from an histogram results in changing the chart from histogram (value x1 from point A to point B, value x2 from point B to point C) to a bar chart (value x1 on point A, value x2 on point B).

They seems to be similar but they hare two different concept and meanings.

[ghudgins]

+1 from discuss

Our application runs between Monday to Friday... and not on Saturday and Sunday. We are creating a chart in Kibana and using the date histogram field for time series. It is showing the weekends as well in the graph. somehow we want to hide weekends in the chart.

https://discuss.elastic.co/t/hide-weekends-for-date-histogram-field-in-time-series-in-graph/305434

[ghudgins]

+1

Think like banking data -> M|Tu|W|Th|F|M|Tu|W|Th|F|M|Tu|W|Th|F|...Never going to have docs on the weekends so the user doesn't want to have gaps when looking at a month+ date range

[ghudgins]

+1

On Weekends Financial markets are closed.So no data is pushed to the index. Due to which seeing gaps in the in viz. I don't want to see the gaps.

[timductive]

Closing this because it's not planned to be resolved in the foreseeable future. It will be tracked in our Icebox and will be re-opened if our priorities change. Feel free to re-open if you think it should be melted sooner.