grafana之mysql数据源设置变量

SELECT 'DropCounts' AS __text, ROUND((${__to}+1000-${__from})/6000000) AS __value FROM  report  limit 1

SELECT 'OUT_ITEMS' AS __text,  '(401,402, 467,468)' as __value

SELECT 'O_OUTRATE' AS __text, SUM(value) as __value
FROM 
(SELECT  
  date_format(from_unixtime(clock), '%Y-%m-%d %H:%i') as time, value  
FROM  history
WHERE itemid IN ${OUT_ITEMS}
AND $__unixEpochFilter(clock)
ORDER BY time
  ) 
AS temp 
GROUP BY time
ORDER by __value 
DESC LIMIT ${DROPCOUNTS},1

SELECT 
    unix_timestamp(time) as time_sec, 
    ${O_OUTRATE} as value,
    'Out端口流量95值' as metric  
FROM 
(SELECT  date_format(from_unixtime(clock), '%Y-%m-%d %H:%i') as time
FROM  history
WHERE itemid IN ${OUT_ITEMS}
AND   $__unixEpochFilter(clock)
ORDER BY  time) 
AS temp 
GROUP BY time;