grafana系列(001)------ grafana安装及简单使用 TODO


SELECT
count(id)
FROM
user_main
WHERE
delFlag = 0


SELECT
UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" )) AS time,
sum(fee) as value
FROM order_pay
WHERE
DATE_FORMAT( createTime, "%Y-%m-%d" ) = DATE_FORMAT( NOW(), "%Y-%m-%d" )
GROUP BY UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" ))

SELECT
UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" )) AS time,
SUM(fee) AS value,
'金额(元)' AS metric
FROM order_pay
WHERE
$__timeFilter(createTime)
group by UNIX_TIMESTAMP(DATE_FORMAT( createTime, "%Y-%m-%d" ))

-- gar buage

posted @ 2021-11-02 10:50  请叫我猿叔叔  阅读(277)  评论(0)    收藏  举报