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 ?
