Clickhouse 条形图📊函数展示

Clickhouse 条形图📊函数展示

 

1.bar(x, min, max, width) 

x:表示数值

min:最小长度

max:最大的长度

width: 宽度

select  DepartmentID,
          round(sum(total),0) as Amount,
          bar(Amount, 0, 600000, 20) AS bar
from test
group by DepartmentID
order by Amount desc ;

 

结果👇：