Fix metrics schedule lag

What does this MR do and why?

This changes DB query to stats for the past 24h. This will limit the amount of data being sent to the page thus reducing the lag for the user.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• Have you checked this doesn't interfere/conflict/duplicate someone elses work?
• Have you fully tested your changes?
• Have you resolved any lint issues?
• Have you assigned a reviewer?
• Have you applied correct labels?