Visual Builder interval should use dateFormat:tz

[LeeDr]

Kibana version: master

Elasticsearch version: master

Server OS version: Ubuntu 14.04

Browser version: Chrome

Browser OS version: Windows 10

Original install method (e.g. download page, yum, from source, etc.): .deb packages from SNAPSHOT builds

Description of the problem including expected versus actual behavior:
As reported here;
https://discuss.elastic.co/t/changing-the-1d-interval-in-visual-builder/87134

Selecting a 1d interval in the Visual Builder seems to always select the time range based on UTC and then show that in the users local time (assuming dateFormat:tz is left at the default browser setting).
So if I'm in the US Central Time zone (-5) then my day buckets will show 7PM to 7PM instead of 00:00:00 or 12AM.

If I leave the default dateFormat:tz: browser it looks wrong to me;

And with the same browser setting other Kibana visualizations show 00:00:00 for the start time if a Daily interval;

If I set my dateFormat:tz: utc

Steps to reproduce:

1. With your computer clock set to something other than UTC, load some test data (at least a couple of days) and Kibana with the default browser setting for dateFormat:tz
2. Create a new Visualization and select Visual Builder
3. Go to Panel Options tab and change the interval to 1d
4. Go back to Data tab and change something else (like the Label) to get the chart to update.
5. Mouse over the dots on the line as shown in the images above.

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

[ElWoodyl]

Hello,

I think I have the same issue, I set the time range at this week or the previous week with interval 1d and I draw a bar chart. This returns a bit of the day before the begin of my time range and the last day seems to be missing in my case.

Here the first bar seems to represent a few hours of Jun 25 which is out of my interval range and July 2nd is missing.

[TheExorcista]

I have the same issue, but I've notice when I modify the time range, visual builder gives me different data from same time period.

[fjiang212]

Do you plan to back port to 5.5.x? I am using 5.5.1 and found similar problem. Last day bar is missing.