Undesired range of x-axis

[tiofaizin]

Hi Looker!

I have two timeseries bar-chart ( A & B ) like this:

The first time I put the graph on the dashboard, the two charts was depicted accordingly. But once I applied a date filter with default in the last 2 days, the chart B x-axis shows unexpected range of times. 

Since I’m using near real-time data, these bar charts will automatically update per 1 hour. The figures above are supposed to show the latest update at 8.00 AM on 2020-11-24. The chart A is apt, the latest time plotted in x-axis is ‘2020-11-24 8’ . But the chart B’s x-axis is not as expected. The chart B’s x-axis is ranging forward far from latest update and have no value since the data is yet unavailable. 

I’m aware there is a ‘Limit displayed rows’ feature on visualization, but I’m sure that won’t gonna help since the undesired additional x-axis range is inconstant.

any help would be much appreciated.

Thanks,

~Tio