Hi, with following query i get total number of logs by label “SipSessionId”. That’s ok, but i would like to have in my stat graph just total number of “unique” SipSessionId labels. Is this possible? QUERY: sum by (SipSessionId)(count_over_time({origin=“MYORIGIN”, SipSessionId=~“.+”} [$__range])…

Finally!!! Found solution with transformation!! QUERY count_over_time({origin=“MYORIGIN”, SipSessionId=~“.+”} [$__range]) [finel_result]

Could you show what you expect to have?

I would like to have a simple graph, like shown, that rapresents total number of “unique” sipsessionid labels. [needed]

Can you try the query: count(count_over_time({origin="MYORIGIN", SipSessionId=~".+"}[$__range]) by (SipSessionId))

Your code give me an error. I have to adjust like this: count(count_over_time({origin=“MYORIGIN”, SipSessionId=~“.+”} [$__range])) by (SipSessionId) but I already tested and I realized that i get same identical result of using “sum by”

Okay, what else did you already try? What’s the error?

Played around “count”… count by, sum, etc but cannot get what i need. If you meant error related to your preview code, this is error: { “request”: { “url”: “api/ds/query?ds_type=loki&requestId=Q936_1”, “method”: “POST”, “data”: { “queries”: [ { “datasource”: { “type”: “loki”, “uid”: “adv…

Tried but not luck. See error. Always it returns “invalid request” and cannot understand why QUERY: count by (SipSessionId)(sum by (SipSessionId)(count_over_time({origin=“MYORIGIN”, SipSessionId=~“.+”} [$__range]))) { “request”: { “url”: “api/ds/query?ds_type=loki&requestId=Q956_1”, “metho…

Ok, I’m not so good with Loki, sorry… Looks like Loki’s having issue to count a sum (which makes sense…). Why the result of your query: sum by(SipSessionId)(count_over_time({origin="MYORIGIN", SipSessionId=~".+"} [$__range])) doesn’t suit you? Looks like the total of unique labels to me…

This is what i need at the end. Sound strange grafana cannot do this simple achivment. [finel_result]

Sum total number of items returned by a LogQL qery

Grafana

codi639 September 2, 2024, 11:56am 8

Seems similar to this issue, can you take a look at it?

Topic		Replies	Views
Count number of unique values without hitting series-limit Grafana Loki	3	1140	June 2, 2025
How do I count lines by labels? Grafana Loki query-help	5	7029	October 14, 2025
Cannot distinct data in Grafana Loki Grafana Loki	9	4531	January 7, 2025
Grafana Loki How to Count unique Values without Limiting? Grafana Loki	1	26	March 25, 2026
Group by label value without timestamps Grafana Loki	2	269	November 7, 2025

Sum total number of items returned by a LogQL qery

Related topics