Grafana graph with prometheus data dynamically starting at zero?

Question

I have a graph over time (mostly "today so far") and would like to start the graph based on prometheus data at zero. Of course the base value changes everytime the range differs so a static value is useless.

Example:

max_over_time(my_metric_counter[${__interval}])

This returns a graph starting somewhere (for example 120 in the current time range). Substracting a static value makes no sense here:

max_over_time(my_metric_counter[${__interval}]) - 120

I already found out what to do - but it took me quite a while. So I want to share this with you...

eventhorizon · Accepted Answer · 2020-06-16 08:48:43Z

2

I am adding a grafana variable as follows:

Name: my_metric_counter_start_value

Type: Query

Hide: Variable

Datasource: MyPrometheusDatasourceName

Refresh: "On time range change"

Query: query_result(min_over_time(my_metric_counter[${__range}]))

Regex: /.} ([0-9]+) ./

The I change my graphs query:

max_over_time(my_metric_counter[${__interval}]) - $my_metric_counter_start_value

And that's it! Hopefully this will help you too ;-)

answered Jun 16, 2020 at 8:48

eventhorizon

3,4279 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Grafana graph with prometheus data dynamically starting at zero?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related