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.