grafana怎么合并2段曲线

pannel里面需要统计09:30~11:30,13:00~15:00两个时间段的数据,但是中间11:30~13:00这段是没有数据的,怎么设置可以去掉中间这一段空白(时间序列设置了09:30~15:00的范围)

两端查询SQL如下:

查询A:

SELECT
  $__timeGroupAlias(create_time,$__interval),
  avg(networth) AS "networth"
FROM tb_networthtrend
WHERE
  code = '005918'
  AND create_time >= CONCAT(CURRENT_DATE(),' 09:30:00')
  AND create_time <= CONCAT(CURRENT_DATE(),' 11:30:00')
GROUP BY 1
ORDER BY $__timeGroup(create_time,$__interval)

查询B:

SELECT
  $__timeGroupAlias(create_time,$__interval),
  avg(networth) AS "networth"
FROM tb_networthtrend
WHERE
  code = '005918'
  AND create_time >= CONCAT(CURRENT_DATE(),' 13:00:00')
  AND create_time <= CONCAT(CURRENT_DATE(),' 15:00:00')
GROUP BY 1
ORDER BY $__timeGroup(create_time,$__interval)

 

你好,谢谢你的回答。按照你的建议,结果是下面这样的:

 

中间这一段能去掉吗,能不能做到类似这样的效果?