Hi all , Im looking for a way to turn the null/no data return to zero in logql. Im trying to get the percent of the request just like sum(count_over_time({app="xxx"}|="{"|json|route="POST /api/a" , status=~`200|400|401|403|429|404` [1m])) / sum(count_over_time({app="xxx"}|="{"|json|route="POST /ap…

This is a good question, I’m not sure if this is currently possible but will ask the team for options here!

I am also interested in this. Any way to make a logql query return zero when theres no data ?

It’d be really helpful to get an answer on this. Now that we can alert based on Loki LogQL metric queries, sending alerts based on error logs seems like a common use case. But if your query returns no data when there are no error logs, it’s impossible to get your alert to work properly.

this is a useful feature, like the or on() vector(0) in prometheus query, which will help on alerting and also some calculation. Any progress on it?

Came up with kinda ugly solution. Basic idea is that you should negate your regexp first, and than subtract this value from sum without conditions. Something like this: sum(x) - sum ( x | code !~"^5…")

I agree that this is a useful feature. For example if I display graph line of number of errors in logs - if there are none I want it to be displayed as 0 and that it won’t disappear from the graph.

I used a Grafana transformation which seems to work Add field from calculation → Binary operation Select the query and do + 0 I then hide the original query It would be easier if we could do this in the original query though

Agreed! I opened a discussion on Github as well to follow this: How can i turn no data to zero in Loki · Discussion #39742 · grafana/grafana · GitHub

If we have an option to join with a vector of 0 and do a sum, would be good.

How can i turn no data to zero in Loki

Grafana Loki

gabe19 June 4, 2024, 9:44pm 13

The transformation hack no longer appears to work.

Topic		Replies	Views
Xx_over_time leads to no-data -> no calculations/operations possible ~ Please help Grafana Loki	5	2830	December 20, 2023
Unified alerts query missing "no data" data points Grafana	4	2727	October 11, 2022
Error when using count with no results in grafana Grafana Loki	2	1374	October 11, 2022
Logql - how to cast litertal to vector Grafana Loki alerting	1	619	November 11, 2022
How to handle "aspercent" when both input to it is zero Grafana	7	5547	September 14, 2017

How can i turn no data to zero in Loki

Related topics