sum of count_over_time by day

Question

I have the following Loki query in Grafana:

sum(count_over_time({filename="/var/log/cron.log", instance="node01"} |= `ERROR` [$__interval]))

which gives

but I am at a loss trying to group the sum by day.

I tried various versions of sum by (grouping) (expr) but that usually ended in parsing errors. The docs don't seem very "all-encompassing".

I want a table that shows total sum or errors per day (in the given window).

Does this answer your question? [Is it possible to aggregate Loki logs by day on Grafana?](https://stackoverflow.com/questions/69126628/is-it-possible-to-aggregate-loki-logs-by-day-on-grafana) — Michael Doubez, Feb 05 '23 at 16:30

score -1 · Answer 1 · answered Feb 01 '23 at 06:00

-1

You only need to select type: instance in the grafana logql edit box and your problem should be solved.

answered Feb 01 '23 at 06:00

李国忠

1 Answers1