Guys, I need to visualize the error rate of some requests, filtering by the tags that are registered in them. I'm not able to do the lookup correctly. The only way I found was using endpoint.name, but I have now identified that this is returning the wrong data, since there are different services with the same request name, so in this case I am receiving a request with a tag that is not correct.
I'm not able to get the method id to list in the lookup. Is this possible to do?
timeseries
Total = sum(dt.service.request.count),
by:{endpoint.name,dt.entity.service,http.response.status_code}
| lookup [fetch dt.entity.service_method],
sourceField:endpoint.name,
lookupField:entity.name,
fields:{tags,id}
| expand tags