Filtering x-axis by using custom intervals in kibana visualizations

[isharamadhawa]

I have a requirement as the following.
When a Kibana visualization contains a x-axis, can we add an interval options list to filter the x-axis like the drop-down list in Kibana Discover.

Currently we can define the interval when we create a visualization. But I need that to be selected when it is displayed inside a dashboard. Is it possible to add a interval options to a visualize to be filtered in the dashboard level?

[ShanChathusanda93]

Hi @isharamadhawa,
This feature will give the dashboard viewers to filter the timestamp of the X-axis as their preferences.

[elasticmachine]

Pinging @elastic/kibana-app

[duplostudio]

+1 totally

The words "Filtering x-axis by" in the title of this issue can be misleading, I think this is not about filtering, it is about letting user to set buckets or intervals in x-axis from visualization in dashboard. @ShanChathusanda93 explained the goal perfectly.

This is a very common business use case for this feature: Evaluating business orders and revenue. With the time filter you set a timespan, for example "last 2 month", but with "auto" this can lead to non natural or fractional intervals for business users (half an hour, half days, days and a half, joining 2 or more day results in 1 bar...). Setting fixed interval other than "auto" at visualization design limits seriously data drilling, for example using the same chart to visualize orders placed each day in the timespan and orders placed along a day when the timespan is small enough (answering to business question "when are we making more money along the day?").

Manually setting the daily, weekly or monthly buckets in Visualizations in Dashboards as in Discovery chart UI solves the problem, giving the user the flexibility to force bucket size to standard intervals (respecting min and max limits set in general config to avoid for example bucketing a year in seconds).

In detail, it could be done system adding a new bucket/interval definition option like "auto": "manual" or "interactive".

If this option is selected, dscTimechart__header is attached into the visualization component, reusing the selection logic of interval treatment in Discover chart.

I think this could be a great improvement in UX.

[matip]

We would also be very interested in that feature

[ThomThomson]

Closing this in favour of a more general idea, embeddable variables. #134706 That generic system could be used to provide this behaviour.