Gantt Chart not showing data

Grafana Dashboards
1

Hello guys,

I’m currently working on a gantt chart. I have insert my data using SQL query but the results are not showing on the panel.

Here’s my SQL Query:
SELECT

lightColour, 
DATEDIFF(s, timeStarted, GETDATE()) as StartTime,
DATEDIFF(s, timeEnded, GETDATE()) as EndTime
FROM tb_Events

Here’s the table view of my data:

image
image1492×172 10.6 KB

The data is Formatted as “Table”.

Am I missing something?

Thank you in advance for any help.

Thank you thank you,
Kevin.

3

Hello Mr Yosiasz,

Thank you very much for the quick response.

May I know what’s the number column for ?

Here’s the value of my table.
image

4

Hello Mr Kevin

Please post your data not as an image but inline csv text?

id,lightID, state,timeStarted,timeEnded,remark,lightColour
1,1,1,2022-06-30 10:08:20.000,

etc

5

Sure thing.

Here’s the data inline

ID,lightID,state,timeStarted,timeEnded,remark,lightColour
1,1,1,2022-06-30 10:08:20.000,2022-06-30 10:38:20.000,NULL,Red
6,1,1,2022-06-30 11:28:20.000,2022-06-30 11:48:20.000,NULL,Red
7,2,2,2022-06-30 10:38:20.000,2022-06-30 11:28:20.000,NULL,Green
8,3,1,2022-06-30 11:48:20.000,2022-06-30 12:18:20.000,NULL,Blue
9,3,1,2022-06-30 11:48:20.000,2022-06-30 12:18:20.000,NULL,Blue
1 Like
7

Yes sir! This is exactly what I needed ! Can you please share the code please. Thank you thank you !

9

Thank you very much for the help kind sir ! I have successfully got it to work. You are my saviour ! TQ TQ.

1 Like