代码编辑区添加两个查询,以展示不同的数值
Query A:
SELECT block_time AS time_seq, power/pow(1024,4) as value, actor || ' 原值算力' AS metric FROM lotus_miners WHERE $__unixEpochFilter(block_time) and actor = 't02438' ORDER BY 1,2 desc
Query B:
SELECT block_time AS time_seq, quality_adj_power/pow(1024,4) as value, actor || ' 有效算力' AS metric FROM lotus_miners WHERE $__unixEpochFilter(block_time) and actor = 't02438' ORDER BY 1 desc
编辑sql后,两个数值均将默认在左侧坐标轴显示。
现在,我们来设置一下双坐标轴显示。
在右侧面板设置区,找到Series overrides,设置系列优先规则。
点击+号,添加一个规则,alias or regex 文本框中选择需要在Y右侧坐标轴展示的别名。
在下拉的规则中,选择Y-axis,并选择值2.
最终展示效果