Graph display how can i do

1

hi
datasource is ： mysql

my query sql is ： SELECT UNIX_TIMESTAMP(T.createdate) as time_sec,T.type_value as VALUE,T.col_type as metric FROM mytest T WHERE T.col_type = ‘A’

query result is ：image

bug grafana view is ：

image
image1908×925 104 KB

how can i do that let graph display

2

try returning a value column (lowercase). Also make sure the time points are within the dashboard time range (and include a $__timeFilter macro)

1 Like
3

Thank you very much for your answer