Hi i am using loki data source to build dashboard from m,y logs which are of following format
[11/Oct/2023:13:40:24 +0530] | 404 | 1 ms | 807 B | 172.31.0.88 | - | - | - | "GET /3dcomment/monitoring/healthcheck HTTP/1.1"
[11/Oct/2023:13:40:21 +0530] | 503 | 0 ms | 299 B | 172.31.0.88 | - | - | - | "GET /3dnotification/healthcheck HTTP/1.1"
[11/Oct/2023:13:40:14 +0530] | 200 | 11 ms | 16 B | 172.31.0.88 | - | - | - | "GET /3ddashboard/test-alive HTTP/1.1"
And i am using the following query to parse the log line to and draw a stacked bar graph
query 1
{job="apache-logs"} != `server-status` | regexp `^\[(?P<datetime>.+)\]\s\|\s(?P<response>\S+)\s\|\s(?P<duration>\S+)\sms\s\|\s(?P<bytes>\S+)\sB\s\|\s(?P<remoteIP>\S+)\s\|\s(?P<clientIP>\S+)\s\|\s(?P<token>\S+)\s\|\s-\s\|\s"(?P<method>\S+)\s\/(?P<service>\S[^\/]+)(\/(?P<url>\S+))?\s(?P<protocol>\S+)".*$`
query 2
sum by(service) (sum_over_time({job="apache-logs"} != `server-status` | regexp `^\[(?P<datetime>.+)\]\s\|\s(?P<response>\S+)\s\|\s(?P<duration>\S+)\sms\s\|\s(?P<bytes>\S+)\sB\s\|\s(?P<remoteIP>\S+)\s\|\s(?P<clientIP>\S+)\s\|\s(?P<token>\S+)\s\|\s-\s\|\s"(?P<method>\S+)\s\/(?P<service>\S[^\/]+)(\/(?P<url>\S+))?\s(?P<protocol>\S+)".*$` | unwrap bytes | __error__=`` [$__interval]))
i have put the datetime label on x axis
Now i have a table in another dashboard which will display the details of byte consumption for every service.
Based on the service i select in the first dashboard i want to navigate to the second dashboard with the table data filtering only those value of selected service and time on x axis.
The first graph shows sum of bytes per service at that time on x axis. in the second dashboard i want entry for every byte consumption for selected service. How can i achieve this? tried all possible documents but i’m not getting anything