Hopefully https://github.com/prometheus/prometheus/pull/14095 is accepted. It would make these kinds of queries much easier and faster. No subquery required.
On Mon, Jun 24, 2024 at 2:50 PM 'Brian Candler' via Prometheus Users < prometheus-users@googlegroups.com> wrote: > A PromQL query like "mymetric == bool 2" will return 1 when the value is > 2, and 0 otherwise. > > You'll likely need to run this inside a subquery if you're doing time > range aggregation over it. But if Grafana is doing the summarization that > might not be necessary. > > On Monday 24 June 2024 at 13:38:03 UTC+1 Ben Kochie wrote: > >> IMO you need to fix your service metrics. Prometheus best practice is to >> follow the pattern of probe_success. Boolean values are far easier to >> handle. >> >> On Mon, Jun 24, 2024 at 2:36 PM Raúl Lopez <hostinger...@gmail.com> >> wrote: >> >>> Hello, >>> I need to know in percentage the time my service has been available in >>> the last month, last week, etc (dynamic value). >>> The metric in question can return the values; 0, 1 and 2. >>> >>> 0 -> OK >>> 1 -> Warning >>> 2 -> KO >>> >>> The idea I have is to disregard value 1 and only treat my service as KO >>> when it has returned value 2. I am trying to build in a Grafana >>> visualisation for the SLA in percentage that my service has been available >>> according to the time range that the user specifies in the dashboard. >>> >>> I've been doing some research and it seems that for this kind of cases >>> it is not as simple as for example for those endpoints where Blackbox is >>> used for example (as I cannot use probe_success). >>> >>> Could someone help me? >>> Thank you in advance. >>> >>> Regards. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Prometheus Users" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to prometheus-use...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/prometheus-users/a26d17b9-b507-413a-89d7-f95ca49ef725n%40googlegroups.com >>> <https://groups.google.com/d/msgid/prometheus-users/a26d17b9-b507-413a-89d7-f95ca49ef725n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > You received this message because you are subscribed to the Google Groups > "Prometheus Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to prometheus-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/c4ec7e1e-d850-4a1e-bc43-de33a12d464dn%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/c4ec7e1e-d850-4a1e-bc43-de33a12d464dn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to prometheus-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CABbyFmqRgx9gTkTjbxi6htcEe9xxjyhox%2BEg0ad6EB16c0H-0g%40mail.gmail.com.
