Relative timepicker: make "to" date customizable

[ycombinator]

(This came up in a Kibana public training)

The use case

The specific use case that came up is as follows:

• Each document represents a person's profile.
• Each document contains a datetime field, say lastEdited, for when the profile was last edited.
• User wants to create visualizations on their data, add them to a dashboard, then restrict the documents to profiles that have not been edited in the past 2 days.
• They want to save this search with the relative end date, so whenever the dashboard is loaded up, the end point of the datetime range is always 2 days ago at the time.

The current solution space

AFAIK, there's currently no way to specify relative timestamp (e.g. -2d) with Lucene query syntax. They could create a filter on the lastEdited field, and edit the JSON into a range query, but that's clunky. Along similar lines, they could enter query DSL in the search bar to enter a range query with a relative timestamp.

The feature request

This would be possible via the UI if the Relative timepicker allowed to to field to be editable. Then the user could set their index pattern's time field to lastEdited and set the to field in the Relative timepicker to 2 days ago.

[tbragin]

@ycombinator is this what you are looking for? #10990

If so, it just went out in 5.4