Yuri Astrakhan
Yuri Astrakhan

Reputation: 9955

Grafana: Calculating single value growth percentage from sum(series)

Given a set of series aaa.bbb.*.ccc. I need to sum up all series, and show a single value - the percentage increase of LAST value compared to the last available value 1 month ago. In other words: (last_now - last_1m_ago) / last_1m_ago. I know I can "Override relative time" with "1M" value, but single number calculation escapes me. Thanks!

Upvotes: 1

Views: 1430

Answers (1)

AussieDan
AussieDan

Reputation: 2176

You'll want something like:

asPercent(sumSeries(aaa.bbb.*.ccc), timeShift(sumSeries(aaa.bbb.*.ccc), "1mon"))

Upvotes: 1

Related Questions