天天看點

grafana系列(001)------ grafana安裝及簡單使用 TODO

grafana系列(001)------ grafana安裝及簡單使用 TODO

SELECT

count(id)

FROM

user_main

WHERE

delFlag = 0

grafana系列(001)------ grafana安裝及簡單使用 TODO

$__timeGroupAlias(createTime, '1h'),

sum(fee) as value

FROM order_pay

GROUP BY 1

ORDER BY 1

grafana系列(001)------ grafana安裝及簡單使用 TODO

UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" )) AS <code>time</code>,

SUM(fee) AS value,

'金額(元)' AS metric

$__timeFilter(createTime)

group by UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" ))

繼續閱讀