Can't set colours on date range visulation when using now in a date range aggregation

[walrusVision]

Kibana version: 5.5.2

Elasticsearch version: 5.5.2

Server OS version: Ubuntu 16

Original install method (e.g. download page, yum, from source, etc.): Debian install

Description of the problem including expected versus actual behavior:
If you set custom colours on a graph which are using an aggregation from a date range with now in the date format, then the colours will not stay after refreshing. I would except to be able to keep the colours for the defined series. As far as I can tell this effects any graph type using now in a date range aggregation.

After reading #9219 and #12914 what I believe to be happening is this:

• The label for a data range such as now-1w to now will be rendered dynamically and will become a label like August 24, 12:00:00.00 to August 17 12:00:00.00
• The colour will be saved statically against that label e.g "uiStateJSON": "{\"vis\":{\"colors\"{\"August 24, 12:00:00.00 to August 17 12:00:00.00\":\"#BF1CB00\"}}}"
• When you refresh now now refers to a time in the future and the previously saved label will no longer match.

Steps to reproduce:

1. Make a bar chart graph against data with a time range
2. For the bucket make a date range aggregation (or sub aggregation) with something like From = now-1w and To = now
3. Pick a colour for the range
4. Save
5. Refresh

[anthonyscarfe]

This still exists in 7.10.

I also created two variants of the same visualization with rounding applied to the date range (using now/1d and now/1h).

With rounding applied, the selected colours will persist for the period specified in the rounding. This seems to confirm the theory above, that the issue is caused by static times being used in uiStateJSON.

[flash1293]

Closing this issue because this will be supported in Lens visualizations soon (tracked by #101942 )

Since this would require a large development effort to implement in Visualize/TSVB and our efforts are focused on extending the functionality of Lens in easy-to-use and consistent way. We aim to provide the best possible visualization editing experience in Lens and are working to improve that tool and help users migrate.