Sum per time interval?

[Harmen B]

Hi!

is there a way to sum() a counter per time period?

I have a counter of which I would like to graph the sum per (UTC) day, with a reset at midnight, counting upwards during the day. A single number per day would be fine.

I can see this work with a Gauge, to which I .Add() all day, with somehow a Set(0) at midnight, but that sounds ugly. Any other ideas?

Thanks!

Harmen

[Fabian Reinartz]

Hi,

you can use the increase() function in an instant query evaluated at 00:00h with a 24h window (`increase(my_counter[24h])`).

This will return you the number by which the counter increased the past day. No need to modify the metrics themselves.

Cheers,

Fabian

--
You received this message because you are subscribed to the Google Groups "Prometheus Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-devel...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Harmen B]

Hi,

thanks for your reply. That means I still have to call the query at 00:00h sharp every day and store the result somehow. Right?

I was hoping for something akin to postgres' date_trunc http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

[Brian Brazil]

On Thu, Nov 12, 2015 at 3:36 PM, Harmen B <har...@typetypetype.net> wrote:

Hi,

thanks for your reply. That means I still have to call the query at 00:00h sharp every day and store the result somehow. Right?

The API supports passing a timestamp: http://prometheus.io/docs/querying/api/#expression-queries

Brian

--

Brian Brazil

www.robustperception.io

[Harmen B]

So then it's a cron which runs daily, a little after midnight, calculating the total from yesterday with `increase(mycounter[1d])`, and put that in a new gauge. Right?

Thanks!

Harmen

[mounia zadel]

Le mardi 17 juillet 2018 20:02:05 UTC+1, mounia zadel a écrit :

I have a table which will log all the data based on one minute interval. Now I want to retrieve the records such that, if the time interval is given 2 minutes it should add the complete records with 2 minutes interval and show on screen .I watch this vedeo to an article  https://bluestacks.vip/, https://textnow.vip/, https://photomath.vip/