如何每天在Grafana表中汇总指标? [英] How can I aggregate metrics per day in a Grafana table?

问题描述

我正在用Grafana表绘制数据图表，我想将一天中的所有数据点汇总到表的一行中.正如您在下面看到的，我当前的设置以每分钟为单位显示值.

I am charting data with a Grafana table, and I want to aggregate all data points from a single day into one row in the table. As you can see below my current setup is displaying the values on a per / minute basis.

问题:我如何制作一个Grafana表来显示按日汇总的值?

Question: How can I make a Grafana table that displays values aggregated by day?

|        Day        | ReCaptcha  | T & C |
|-------------------|------------|-------|
| February 21, 2017 |   9,001    | 8,999 |
| February 20, 2017 |      42    |    17 |
| February 19, 2017 |     ...    |   ... |

推荐答案

您可以在指标面板上使用摘要功能. 通过按+，然后选择转换来更改查询 summary(24h，sum，false)，它将过去的24hr数据点通过求和而汇总为一个点.

You can use the summarize function on the metrics panel. Change the query by pressing the + then selecting transform summarize(24h, sum, false) this will aggregate the past 24hr data points into a single point by summing them.

http://graphite.readthedocs.io/zh_CN/latest/functions.html#graphite.render.functions.summarize

结果

这篇关于如何每天在Grafana表中汇总指标?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！