[Visualize] [Lens] Inspector 'filter by' creates a standard filter instead of filtering time range for a time interval

[mbondyra]

Kibana version:
7.16, master

Not sure if it's a wanted behavior, so feel free to close it if there's a reason for it.

1. Open Lens visualization and create a datatable visualization with a timestamp column:

2. Click on 'Inspect' and choose 'filter for value' in any of the intervals:

The filter was added:

Works the same across Lens and Visualize.
What we would like instead probably, is to narrow the timerange in a timepicker, just like it behaves when clicking in a table.

Oct-29-2021.13-05-45.mp4

[elasticmachine]

Pinging @elastic/kibana-vis-editors (Team:VisEditors)

[flash1293]

As described here #122113 (comment) , this is blocked on #118851 as we need some additional meta data on the data table to make it work correctly in all cases.

[flash1293]

Actually, this meta data is already available for all cases. If search.aggs.getDateHistogramMetaDataByDatatableColumn(datatableColumn) returns a time range, then this means the column is bound to the global time picker and can change it instead of creating a filter. If it's not returning a time range, then it means a filter needs to be created.

[flash1293]

Just realized this is bigger than VisEditors because this part of the inspector is maintained as part of the data plugin:

kibana/src/plugins/data/public/utils/table_inspector_view/components/data_table.tsx

Line 83 in 9d662b7

id="data.inspector.table.filterForValueButtonTooltip"

@elastic/kibana-app-services Could you take a look at that?

[elasticmachine]

Pinging @elastic/kibana-presentation (Team:Presentation)

[elasticmachine]

Pinging @elastic/kibana-data-discovery (Team:DataDiscovery)

[ThomThomson]

Reassigning this to the Data Discovery team because it looks like the change will need to happen in the Data plugin

[lukasolson]

When creating a data view, you select a time field. In my opinion, the type of filter we create should be based on whether or not the field is the selected time field for the data view. Here's the two scenarios:

1. The date field is the selected time field for the data view - Adjust the time range in the time picker to the selected range.
2. The date field isn't the selected time field for the data view - Create a filter in the filter bar for the selected range.

I believe this is how it has historically worked, and makes the most sense.

[stratoula]

I agree with you Lukas ++