Time Filter components not responding completely

Grafana
1

Hello,

I am trying to use $__timeFilter for my graph panel with Microsoft SQL Data Source.
The filter does not respond for Last 5 minutes/15/30/1hr/3hrs/6hrs/12hrs/24hrs

It responds only for Today /This week/ This Month/ This year

My datetime column has valid timestamps as below.

2018-07-03 08:08:39.717
2018-07-03 08:49:53.577
2018-07-03 08:50:52.373
2018-07-03 08:52:16.657
2018-07-03 09:26:28.497
2018-07-03 09:27:06.513
2018-07-03 09:00:06.107

Kindly help

Current version: Grafana v5.1.0 (844bdc53a)

image
image856×232 26.1 KB

2

can you paste the query??

3

Hi @sandeepreddy
Can you export data with timestamp to CSV and reply query and data export to this post :smiley:

4

SELECT
__timeEpoch(SvaFinishedTime), (SELECT Count(*) FROM [DB_SVA_TEST_SQL].[dbo].[StatisticSet] WHERE RunName = ‘IsilonCheck’ AND ExecutionStatus = ‘Finished’) as value, InstallationFolder as metric FROM [DB_TEST_SQL].[dbo].[StatisticSet] WHERE __timeFilter(SvaFinishedTime)
ORDER BY SvaFinishedTime ASC

5

I want to use Microsoft SQL DataSource and create a time graph to plot total rows for each hour.

My data:

StatId,TaskId,ClusterName,JobSeqName,RunName,JobName,TaskName,SystemName,InstallationFolder ,Duration,ExecutionStatus,SvaFinishedTime,LastChanged
1,20601,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,61,Finished,02-07-18 12:27:00.210,02-07-18 12:27:00.240
2,20602,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,61,Finished,02-07-18 12:28:01.710,02-07-18 12:28:01.710
3,20603,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,60,Finished,02-07-18 12:29:02.930,02-07-18 12:29:02.930
4,20604,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,61,Finished,02-07-18 12:30:04.167,02-07-18 12:30:04.167
5,20605,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,0,Failed,02-07-18 12:31:05.277,02-07-18 12:31:05.277
6,20606,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,60,Finished,02-07-18 12:32:06.560,02-07-18 12:32:06.573
7,20607,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,60,Finished,02-07-18 12:33:07.873,02-07-18 12:33:07.887
8,20608,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,0,Failed,02-07-18 12:34:09.107,02-07-18 12:34:09.123
9,20609,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,61,Finished,02-07-18 12:35:40.063,02-07-18 12:35:40.077
10,20610,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,60,Finished,02-07-18 12:36:41.250,02-07-18 12:36:41.267
11,20611,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,60,Finished,02-07-18 12:37:42.313,02-07-18 12:37:42.313
12,20612,SCT_Run,testen,IsilonCheck,testen,testen,abts5333,abts5333_C:\temp,0,Failed,02-07-18 12:38:18.987,02-07-18 12:38:18.987

My query:
SELECT
__timeEpoch(SvaFinishedTime), (SELECT Count(*) FROM [DB_SVA_TEST_SQL].[dbo].[StatisticSet] WHERE RunName = ‘IsilonCheck’ AND ExecutionStatus = ‘Finished’) as value, InstallationFolder as metric FROM [DB_TEST_SQL].[dbo].[StatisticSet] WHERE __timeFilter(SvaFinishedTime)
ORDER BY SvaFinishedTime ASC

7

can somebody help me with this, i really need to get this up and running by 16/07/2018