Fill X axis with hourly data

Grafana Time Series Panel
,
1

Hi. I am displaying power data (watts) recorded every minute. I am also in the same Time series plot displaying power price on a separate Y axis. The power price is recorded every hour and I always have prices available into the future.

My problem is that if I display the power and price the last X hours the plot for the price starts at the first whole hour and ends at the last whole hour.
How can I extend the query from the MySQL database so the price plot fills the X axis

Screenshot of one power consumer and power price the last 3 hours.

image
image1595×508 69 KB

2

I found a solution. I changed the WHERE clause in the SQL from
$__timeFilter(time)
to:
time BETWEEN FROM_UNIXTIME($__unixEpochFrom()-3600) AND FROM_UNIXTIME($__unixEpochTo()+3600)