grafana怎么合并2段曲线

Question

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)

Answer 1