How to combine many requests from multiple query to a single cell. (Loki)

  • What Grafana version and what operating system are you using?
    8
  • What are you trying to achieve?
    i try to combine many requests (like /imgpx/asd, /imgpx/asd2 etc. to"imgpx/") to one with regex
  • How are you trying to achieve it?
    In panel settings

screenshots? I think we need more info here to help you

Please, say what info i should give?
we are using Loki as a Data Sourse, panel – Time Series
my query something like that:

sum by (url)
(count_over_time(
{'labels'}
|~ "\"response_code\":\"5.*\"" 
| json 
[$__interval]))

In screenshot above I try to show that i have a few strings with different urls which show how much 5xx errors we have on that url.
I want to merge all strings which starts from /imgprx/.* and summarize their values

Hi, have the same problem. Same errors are summed, but clientid is also part of the label message, so they are seperated. I want all of them summarized into one. ClientId is unimportant

Query:
sum by(message) (count_over_time({customer=“123”,product=“456”} | json | level=“ERROR” [1s]))

Why i do this?:
I want to display the most common errors

Not shure if there is more info needed. Please reach out to me

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.