https://community.splunk.com/t5/Splunk-AppDynamics/SQL-Dashboard-Help/m-p/731826#M7741 <P>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</P><P>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</P><P>On "Set Metric" window, I have selected it as Single Metric and Value</P><P>Data as below</P><P>Time&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Count</P><P>05:00 am&nbsp; &nbsp; &nbsp; &nbsp;10</P><P>06:00 am&nbsp; &nbsp; &nbsp; &nbsp; 20</P><P>07:00 am&nbsp; &nbsp; &nbsp; &nbsp; 30</P><P>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 ?</P> Tue, 22 Aug 2023 07:40:55 GMT Jaydev_Patil 2023-08-22T07:40:55Z https://community.splunk.com/t5/Splunk-AppDynamics/SQL-Dashboard-Help/m-p/731826#M7741 <P>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</P><P>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</P><P>On "Set Metric" window, I have selected it as Single Metric and Value</P><P>Data as below</P><P>Time&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Count</P><P>05:00 am&nbsp; &nbsp; &nbsp; &nbsp;10</P><P>06:00 am&nbsp; &nbsp; &nbsp; &nbsp; 20</P><P>07:00 am&nbsp; &nbsp; &nbsp; &nbsp; 30</P><P>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 ?</P> Tue, 22 Aug 2023 07:40:55 GMT https://community.splunk.com/t5/Splunk-AppDynamics/SQL-Dashboard-Help/m-p/731826#M7741 Jaydev_Patil 2023-08-22T07:40:55Z