SQL Dashboard Help

[Jaydev.Patil]

I'm trying to set query on dashboard as metric, if data looks like below I'm expecting it to show aggregate count at 07:00 am

I have already set query as metric, it fetches count of data from last one hour also schedule on Metrics is set to 1 hour

On "Set Metric" window, I have selected it as Single Metric and Value

Data as below

Time             Count

05:00 am       10

06:00 am        20

07:00 am        30

With current set up I'm not getting aggregate count that is in the database at 06:00 or 07:00 am. could someone help please ?