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]

Sum total number of items returned by a LogQL qery

codi639 September 2, 2024, 11:56am 8

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

Topic		Replies	Views
Loki Query for Counting Logs by Status Code Grafana Loki query-help	6	216	December 29, 2024
LogQL - Metric Query: Sum By Device ID Grafana Loki loki , query-help	2	513	March 16, 2024
`sum(count_over_time({...}[$__range])) group by (...)` counts an entry where there is none Grafana Loki	1	405	October 20, 2023
Live users count based on logs Grafana Loki loki , metrics	2	94	October 22, 2024
Grouping (and counting) by unique values Grafana Loki	2	2995	July 1, 2023